{"text_format":"1","workbook":"xlsx","n_sheets":75,"sheets":["Data Summary","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70","71","72","73","74"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Summary","index":0,"n_rows":78,"n_cols":1,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["Report Name"]
["Table 1 : SEBI Registered Market Intermediaries/Market Infrastructure Institutions"]
["Table 2 : Company-wise Capital Raised through Public and Rights Issues (Equity) during the month"]
["Table 3 :  Open Offers Closed under SAST Regulations (during the month)"]
["Table 4 : Substantial Acquisition of Shares and Takeovers"]
["Table 5 : Capital Raised from the Primary Market through  Public and Rights Issues"]
["Table 6 : Issues Listed on SME Platform"]
["Table 7 : Industry-wise Classification of Capital Raised through Public and Rights Issues (Equity)"]
["Table 8 : Sector-wise and Region-wise Distribution of Capital Mobilised through Public and Rights Issues (Equity)"]
["Table 9 : Size-wise Classification of Capital Raised through Public and Rights Issues (Equity)"]
["Table 10 : Capital Raised by Listed Companies from the Primary Market through QIPs"]
["Table 11 : Preferential Allotments Listed at Stock Exchanges"]
["Table 12 : Private Placement of Corporate Debt Reported to Stock Exchanges"]
["Table 13 : Trading in the Corporate Debt Market"]
["Table 14 : Ratings Assigned for Long-term Corporate Debt Securities (Maturity ≥ 1 year)"]
["Table 15 : Review of Accepted Ratings of Corporate Debt Securities (Maturity ≥ 1 year)"]
["Table 16 : Distribution of Turnover on Cash Segments of Stock Exchanges  (₹crore)"]
["Table 17 : Trends in Cash Segment of BSE"]
["Table 18 : Trends in Cash Segment of NSE"]
["Table 19 : Trends in Cash Segment of MSEI"]
["Table 20 : City-wise Distribution of Turnover on Cash Segment of Exchanges "]
["Table 21 : Category-wise Share of Turnover in Cash Segment of BSE"]
["Table 22 : Category-wise Share of Turnover in Cash Segment of NSE"]
["Table 23 : Category-wise Share of Turnover in Cash Segment of MSEI"]
["Table 24 : Component Stocks: S&P BSE Sensex "]
["Table 25 : Component Stocks: Nifty 50 Index "]
["Table 26 : Component Stocks: SX40 Index during   "]
["Table 27 : Advances/Declines in Cash Segment of Exchanges"]
["Table 28 : Trading Frequency in Cash Segment of of Exchanges"]
["Table 29 : Daily Volatility of Major Indices  "]
["Table 30 : Percentage Share of Top ‘N’ Securities/Members in Turnover of Cash Segment of Exchanges "]
["Table 31 : Settlement Statistics for Cash Segment of ICCL"]
["Table 32 : Settlement Statistics for Cash Segment of NSCCL"]
["Table 33 : Settlement Statistics for Cash Segment of MCCIL"]
["Table 34 : Trends in Equity Derivatives Segment at BSE (Turnover in Notional Value)"]
["Table 35 : Trends in Equity Derivatives Segment at NSE (Turnover in Notional Value)"]
["Table 36 : Settlement Statistics in Equity Derivatives Segment "]
["Table 37 : Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of BSE"]
["Table 38 : Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of NSE"]
["Table 39 : Instrument-wise Turnover in Index Derivatives at BSE"]
["Table 40 : Instrument-wise Turnover in Index Derivatives at NSE"]
["Table 41 : Trends in Currency Derivatives Segment at BSE"]
["Table 42 : Trends in Currency Derivatives Segment at NSE"]
["Table 43 : Trends in Currency Derivatives Segment at MSEI"]
["Table 44 : Settlement Statistics of Currency Derivatives Segment "]
["Table 45 : Instrument-wise Turnover in Currency Derivative Segment of BSE"]
["Table 46 : Instrument-wise Turnover in Currency Derivatives of NSE"]
["Table 47 : Instrument-wise Turnover in Currency Derivative Segment of MSEI"]
["Table 48 : Maturity-wise Turnover in Currency Derivative Segment of BSE "]
["Table 49 : Maturity-wise Turnover in Currency Derivative Segment of NSE "]
["Table 50 : Maturity-wise Turnover in Currency Derivative Segment of MSEI "]
["Table 51 :  Trading Statistics in Interest Rate Futures Segment "]
["Table 52 : Settlement Statistics in Interest Rate Futures Segment"]
["Table 53 : Trends in Foreign Portfolio Investment"]
["Table 54 : Notional Value of Offshore Derivative Instruments (ODIs) compared to Assets Under Custody (AUC) of FPIs/Deemed FPIs"]
["Table 55 : Assets under the Custody of Custodians"]
["Table 56 : Trends in Resource Mobilization by Mutual Funds"]
["Table 57 : Status of Mutual Funds Industry in India"]
["Table 58 : Trends in Transactions on Stock Exchanges by Mutual Funds"]
["Table 59 : Assets Managed by Portfolio Managers"]
["Table 60 : Progress Report of NSDL & CDSL for Listed Companies"]
["Table 61 : Progress of Dematerialisation at NSDL and CDSL (Listed and Unlisted Companies)"]
["Table 62 : Depository Statistics "]
["Table 63 : Number of Commodities Permitted and Traded at Exchanges"]
["Table 64 : Trends in Commodity Indices"]
["Table 65 : Trends in Commodity Derivatives at MCX "]
["Table 66 : Trends in Commodity derivatives at NCDEX"]
["Table 67 : Trends in Commodity Derivatives at ICEX"]
["Table 68 : Trends in Commodity Derivatives Segment at BSE"]
["Table 69 : Trends in Commodity Derivatives Segment at NSE"]
["Table 70 : Participant-wise percentage Share of Turnover in Commodity Derivatives at various Exchanges"]
["Table 71 : Commodity-wise Turnover and Trading Volume at MCX"]
["Table 72 : Commodity-wise Turnover and Trading Volume at NCDEX "]
["Table 73 : Commodity-wise Turnover and Trading Volume at ICEX, BSE and NSE"]
["Table 74 : Macro Economic Indicators"]
[]
[]
["Note- No. - Number"]

{"sheet":"1","index":1,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,2],[40,0,40,3],[41,0,41,3],[43,0,43,3]]}
["Table 1: SEBI Recognised/Registered Intermediaries / Market Infrastructure Institutions"]
["Particular","2019-20","2020-21$"]
["Stock Exchanges (Cash Segment)#",4,3]
["Stock Exchanges (Equity Derivatives Segment)#",3,3]
["Stock Exchanges (Currency Derivatives Segment)#",3,3]
["Stock Exchanges (Commodity Derivatives Segment)#",5,5]
["International Exchange (IFSC)#",2,2]
["Brokers (Cash Segment)",4249,4603]
["Brokers (Equity Derivatives Segment)",3460,3475]
["Brokers (Currency Derivatives Segment)",2708,2707]
["Brokers (Debt Segment)",378,391]
["Brokers (Commodity Derivatives Segment)",2257,2263]
["Corporate  Brokers(Cash Segment)",3231,3550]
["Sub-brokers (Cash Segment)*",0,0]
["Foreign Portfolio Investors (FPIs)",9679,9825]
["Deemed FPI",0,0]
["Custodians",19,19]
["Depositories",2,2]
["Depository Participants (NSDL)",285,285]
["Depository Participants (CDSL)",614,617]
["Merchant Bankers",215,214]
["Bankers to an Issue",66,65]
["Underwriters",2,2]
["Debenture Trustees",31,31]
["Credit Rating Agencies",7,7]
["KYC Registration Agencies (KRA)",5,5]
["Registrars to an Issue & Share Transfer Agents",80,80]
["Venture Capital Funds",189,188]
["Foreign Venture Capital Investors",251,255]
["Alternative Investment Funds",649,697]
["Portfolio Managers",351,358]
["Mutual Funds",47,49]
["Investment Advisors",1291,1344]
["Research Analysts",680,701]
["Infrastructure Investment Trusts (InvITs)",10,10]
["Collective Investment Schemes",1,1]
["Approved Intermediaries (Stock Lending Schemes)",2,2]
["STP (Centralised Hub)",1,1]
["STP Service Providers",2,2]
[]
["Notes:"]
["$ indicates as on October 31, 2020"]
["# SEBI has granted recognition for carrying out operations in the respective segment."]
["Source: SEBI, NSDL."]

{"sheet":"2","index":2,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,9],[19,0,19,5],[21,0,21,5]]}
["Table 2: Company-wise Capital Raised through Public and Rights Issues (Equity) during the month"]
["Sl.No.","Name of the Issuer/Company","Date of Listing","Type of Issue","Type of Instrument","No. of Shares Issued","Face Value (`)","Premium Value (`)","Issue Price (`)","Size of Issue  (` crore)"]
[1,"Computer Age Management Services Limited","2020-10-01","IPO","Equity",18246600,10,1220,1230,2242.11]
[2,"UTI Asset Management Company Limited","2020-10-12","IPO","Equity",38987081,10,544,554,2159.89]
[3,"Angel Broking Limited","2020-10-05","IPO","Equity",19607835,10,296,306,600]
[4,"Mazagon Dock Shipbuilders Limited","2020-10-12","IPO","Equity",30599017,10,135,145,443.69]
[5,"EIH LTD","2020-10-27","Rights Issue","Equity",53794768,2,63,65,349.66]
[6,"Chemcon Speciality Chemicals Limited","2020-10-01","IPO","Equity",9352941,10,330,340,318]
[7,"DEEPAK FERTILISERS & PETROCHEMICALS CORPORATION LTD.","2020-10-26","Rights Issue","Equity",13392663,10,123,133,178.92]
[8,"Likhitha Infrastructure Limited","2020-10-15","IPO","Equity",5100000,10,110,120,61.2]
[9,"RUSHIL DECOR LTD**","2020-10-21","Rights Issue","Equity",4977111,10,40,50,24.88]
[10,"Secmark Consultancy Limited","2020-10-01","BSE SME IPO","Equity",1114000,10,125,135,15.03]
[11,"Atal Realtech Limited","2020-10-15","NSE SME IPO","Equity",1504000,10,62,72,10.83]
[12,"Aaa Technologies Limited","2020-10-13","NSE SME IPO","Equity",2436000,10,32,42,10.23]
[13,"G M Polyplast Limited","2020-10-14","BSE SME IPO","Equity",508800,10,149,159,8.09]
[14,"Sigma Solve Limited","2020-10-19","NSE SME IPO","Equity",1101000,10,35,45,4.9545000000000003]
[15,"Veer Global Infraconstruction Limited","2020-10-19","BSE SME IPO","Equity",1756000,10,18,28,4.9168000000000003]
[16,"Atam Valves Limited","2020-10-06","BSE SME IPO","Equity",1125000,10,30,40,4.5]
[17,"Bodhi Tree Multimedia Limited","2020-10-21","NSE SME IPO","Equity",390000,10,85,95,3.7050000000000001]
["Note: All the issues are compiled from the Prospectus of Issuer Companies filed with SEBI."]
["From April, 2020 onwards the data is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["Source: SEBI."]

{"sheet":"3","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,1],[0,0,0,9],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,6],[1,7,2,7],[1,8,2,8]]}
["Table 3: Open Offers Closed under SAST Regulations (during the month)"]
["Sl.No","Target Company","Acquirer","Offer Opening Date","Offer Closing Date","Offer Size",null,"Offer\n Price \n(`) per share","Offer Size (` crore)"]
[null,null,null,null,null,"No. of \nShares","as per cent of Equity \nCapital"]
[1,"AMAZE ENTERTECH LIMITED","MR. JASPALSINGH PREHLADSINGH CHANDOCK","2020-09-24","2020-10-08",20251400,26,10,20.25]
[2,"CROWN TOURS LIMITED","Mr. Ranjith Soman","2020-09-25","2020-10-09",806000,26,19.25,1.55]
[3,"Stampede Capital Limited","JONNA VENKATA TIRUPATI RAO","2020-09-25","2020-10-09",74428650,26,"0.45/0.55",3.49]
[4,"ACCELYA SOLUTIONS INDIA LIMITED","AURORA UK BIDCO LIMITED","2020-10-05","2020-10-16",3782966,25.34,1042.99,394.55]
[5,"AARTI SURFACTANTS LIMITED","MRS. JAYA CHANDRAKANT GOGRI and NIKHIL HOLDINGS PRIVATE LIMITED ","2020-10-05","2020-10-16",1974965,26,284,56]
[6,"WELCON INTERNATIONAL LIMITED","MR. MURTUZA MANSOORBHAI and MRS. FARHEEN MURTUZA MANSOORBHAI (“PAC 1”) and MRS. SHIVANI SHARDA SHARMA (“PAC 2”)","2020-10-15","2020-10-28",15564120,26,3,4.66]
[]
["Source: SEBI."]

{"sheet":"4","index":4,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,8],[15,0,15,8],[0,0,0,8],[1,0,4,0],[1,1,1,8],[2,1,2,6],[2,7,2,8],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,4,7],[3,8,4,8]]}
["Table 4: Substantial Acquisition of Shares and Takeovers"]
["Year / Month"," Offers"]
[null,"Objectives",null,null,null,null,null,"Total"]
[null,"Change in Control \nof Management",null,"Consolidation of\n Holdings",null,"Substantial \nAcquisition",null,"No. of Offers","Amount (` crore)"]
[null,"No. of Offers","Amount (` crore)","No. of Offers","Amount (` crore)","No. of Offers","Amount (` crore)"]
["2019-20",49,16401.64,4,3641.83,3,478.38,56,20521.849999999999]
["2020-21$",{"$f":"SUM(B8:B14)","v":26},{"$f":"SUM(C8:C14)","v":8958.6},2,9.8699999999999992,2,4.08,30,8972.5499999999993]
["Apr-20",2,1.36,1,2.36,0,0,3,3.72]
["May-20",0,0,0,0,0,0,0,0]
["Jun-20",4,1088.1099999999999,0,0,0,0,4,1088.1099999999999]
["Jul-20",2,528.16,0,0,0,0,2,528.16]
["Aug-20",7,3852.44,1,7.51,1,1.72,9,3861.67]
["2020-09-01",5,3008.03,0,0,1,2.36,{"$f":"B13+D13+F13","v":6},{"$f":"C13+E13+G13","v":3010.3900000000003}]
["2020-10-01",6,480.5,0,0,0,0,6,480.5]
["Note - $ indicates as on October 31, 2020"]
["Source: SEBI."]

{"sheet":"5","index":5,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,15,1,16],[2,3,2,6],[2,7,2,10],[2,11,2,14],[2,15,4,15],[2,16,4,16],[3,13,3,14],[0,0,0,14],[1,0,4,0],[1,1,3,2],[1,3,1,14],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[15,0,15,14],[16,0,16,14],[17,0,17,14],[19,0,19,14],[18,0,18,2]]}
["Table 5:  Capital Raised from the Primary Market through  Public and Rights Issues "]
["Year / Month","Total (Equity + Debt)",null,"Equity Issue",null,null,null,null,null,null,null,null,null,null,null,"Debt Issue"]
[null,null,null,"Category-wise",null,null,null,"Issue-Type",null,null,null,"Instrument-wise",null,null,null,"No. of issue","Amount  (₹crore)"]
[null,null,null,"Public",null,"Rights",null,"Listed",null,"IPOs",null,"At Par",null,"At Premium"]
[null,"No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)"]
["2019-20",{"$f":"D6+F6+P6","v":110},91948.935435799998,60,21322.873772599996,16,55642.041663199998,19,55679.271663200001,57,21285.65,2,8.74,74,76956.181663199983,34,14984.02]
["2020-21$",{"$f":"D7+F7+P7","v":48},84602.620752000003,{"$f":"SUM(D8:D14)","v":27},{"$f":"SUM(E8:E14)","v":22734.661274999999},{"$f":"SUM(F8:F14)","v":14},60536.439477,15,75536.439477000007,26,7734.6612749999986,0,0,41,83271.104452,7,1331.52]
["2020-04-01",4,116.31,3,13.92,0,0,0,0,3,13.92,0,0,3,13.92,1,102.39]
["2020-05-01",1,297.25,0,0,0,0,0,0,0,0,0,0,0,0,1,297.25]
["2020-06-01",{"$f":"D10+F10+P10","v":4},{"$f":"E10+G10+Q10","v":53448.84},1,2.46,1,53124.2,1,53124.2,1,2.46,0,0,2,{"$f":"E10+G10","v":53126.659999999996},2,322.18]
["2020-07-01",6,16070.569975000002,4,15510.779975000001,1,399.79,2,15399.79,3,510.77997499999998,0,0,5,15910.569975000002,1,160]
["2020-08-01",{"$f":"D12+F12+P12","v":9},6107.75,2,11.45,7,6096.3,7,6096.3,2,11.45,0,0,9,6107.75,0,0]
["2020-09-01",6,1821.2944770000001,3,1308.905,2,362.68947700000001,2,362.68947700000001,3,1308.905,0,0,5,1671.5944769999999,1,149.69999999999999]
["2020-10-01",18,6740.6062999999986,14,5887.1462999999985,3,553.46,3,553.46,14,5887.1462999999985,0,0,17,6440.61,1,300]
["Notes:"]
["1. Equity public issues also includes issues listed on SME platform."]
["2. From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["3. The data of Debt is being prepared based on closing date."]
["$ indicates as on October 31, 2020"]
["Source: SEBI."]

{"sheet":"6","index":6,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2],[12,0,12,2],[13,0,13,2],[14,0,14,2]]}
["Table 6:  Issues Listed on SME Platform"]
["Year/Month","No. of issue","Amount  (₹crore)"]
["2019-20",46,495.38279999999992]
["2020-21$",{"$f":"SUM(B5:B11)","v":17},{"$f":"SUM(C5:C11)","v":111.505}]
["2020-04-01",3,13.92]
["2020-05-01",0,0]
["2020-06-01",1,2.46]
["2020-07-01",2,14.53]
["2020-08-01",2,11.45]
["2020-09-01",1,6.8849999999999998]
["2020-10-01",8,62.26]
["Notes -"]
["From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["$ indicates as on October 31, 2020"]
["Source: SEBI"]

{"sheet":"7","index":7,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,0,29,6],[0,0,0,6],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[27,0,27,6]]}
["Table 7:  Industry-wise Classification of Capital Raised through Public and Rights Issues (Equity)"]
["Industry","2019-20",null,"2020-21$",null,"2020-10-01"]
[null,"No. of issues","Amount (₹crore)","No. of issues","Amount (₹crore)","No. of issues","Amount (₹ crore)"]
["Airlines",0,0,0,0,0,0]
["Automobiles",0,0,0,0,0,0]
["Banks/FIs",0,0,2,15119.896001999999,0,0]
["Cement/ Constructions",0,0,3,22.65,2,15.75]
["Chemical",3,141.13588200000001,3,993.17,2,496.92]
["Consumer Services",2,81.78,4,487.06,1,4.5]
["Electronic Equipments/ Products",2,1347.19,1,6.89,0,0]
["Engineering",2,489.32,3,515.4,2,504.89]
["Entertainment",1,2.27,2,303.49,1,3.71]
["Finance",0,0,3,5002,3,5002]
["Food processing",0,0,0,0,0,0]
["Healthcare",3,1267.02,0,0,0,0]
["Hotels",1,3.6,1,349.66,1,349.66]
["Info Tech",0,0,6,1336.25,3,30.21]
["Misc",4,87.06,6,4972.9399999999996,1,24.88]
["Roads & Highways",0,0,1,4.55,0,0]
["Telecom",2,49938.79,0,0,0,0]
["Textile",0,0,1,995.12,0,0]
["Plastic",0,0,2,10.55,1,8.09]
["Power",0,0,0,0,0,0]
["Printing",1,6.58,1,2.4,0,0]
["Oil & Natural Gas",0,0,2,53149.07,0,0]
["Insurance",0,0,0,0,0,0]
["Total",{"$f":"SUM(B4:B26)","v":21},53364.745882000003,{"$f":"SUM(D4:D26)","v":41},{"$f":"SUM(E4:E26)","v":83271.096002000006},17,6440.6100000000006]
["Notes - From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["$ indicates as on October 31, 2020"]
["Source: SEBI."]

{"sheet":"8","index":8,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,2],[0,0,0,11],[1,0,3,0],[1,1,2,2],[1,3,1,6],[1,7,1,16],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12],[2,13,2,14],[2,15,2,16],[13,0,13,11],[13,12,13,14],[14,0,14,2]]}
["Table 8:  Sector-wise and Region-wise Distribution of Capital Mobilised through Public and Rights Issues (Equity)"]
["Year / Month","Total",null,"Sector-wise",null,null,null,"Region-wise"]
[null,null,null,"Private",null,"Public",null,"Northern",null,"Eastern",null,"Western",null,"Southern",null,"Central"]
[null,"No. of Issue","Amount (₹crore)","No. of Issue","Amount (₹ crore)","No. of Issue","Amount (₹ crore)","No. of Issue","Amount (₹ crore)","No. of Issue","Amount (₹ crore)","No. of Issue","Amount (₹ crore)","No. of Issue","Amount (₹ crore)","No. of Issue","Amount (₹ crore)"]
["2019-20",{"$f":"D5+F5","v":76},{"$f":"E5+G5","v":76964.921663200003},74,75849.851663199996,2,1115.0700000000002,17,39089.743609999998,0,0,51,34666.080000000002,8,3209.0995856999998,0,0]
["2020-21$",{"$f":"SUM(B7:B13)","v":41},{"$f":"SUM(C7:C13)","v":83271.104452000014},40,82827.414452000012,1,443.69,6,681.50947700000006,2,429.19000000000005,28,77638.014974999998,5,4522.3899999999994,0,0]
["2020-04-01",3,13.92,3,13.92,0,0,0,0,0,0,3,13.92,0,0,0,0]
["2020-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2020-06-01",2,{"$f":"E9+G9","v":53126.66},2,53126.66,0,0,0,0,0,0,2,53126.66,0,0,0,0]
["2020-07-01",5,15910.569975000002,5,15910.569975000002,0,0,2,14.53,0,0,3,15896.039975000002,0,0,0,0]
["2020-08-01",9,{"$f":"E11+G11","v":6107.75},9,6107.75,0,0,1,299.79000000000002,1,79.53,5,4211.37,2,1517.06,0,0]
["2020-09-01",5,1671.5944769999999,5,1671.5944769999999,0,0,2,362.68947700000001,0,0,2,606.88499999999999,1,702.02,0,0]
["2020-10-01",{"$f":"D13+F13","v":17},{"$f":"E13+G13","v":6440.61},16,5996.92,1,443.69,1,4.5,1,349.66,13,3783.14,2,2303.31,0,0]
["Notes - From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["$ indicates as on October 31, 2020"]
["Source: SEBI."]

{"sheet":"9","index":9,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,0,12,14],[14,0,14,2],[0,0,0,13],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14]]}
["Table 9:  Size-wise Classification of Capital Raised through Public and Rights Issues (Equity)"]
["Year / Month","Total",null,"< 5 crore",null,"≥ 5crore - < 10crore",null,"  ≥ 10 crore - < 50 crore",null,"  ≥ 50 crore - < 100 crore",null,"  ≥ 100 crore - < 500 crore",null,">=500 crore"]
[null,"No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)"]
["2019-20",76,76964.911663199993,19,59.28,12,89.88,24,481.42686700000002,1,60,8,2606.6236902000001,12,73667.701105999993]
["2020-21$",{"$f":"SUM(B6:B12)","v":41},{"$f":"SUM(C6:C12)","v":83271.104974999995},9,34.75,4,30.154999999999998,6,96.35,2,140.73000000000002,10,2964.7699750000002,10,80004.350000000006]
["2020-04-01",{"$f":"D6+H6+L6+N6+F6+J6","v":3},13.919999999999998,2,5.64,1,8.2799999999999994,0,0,0,0,0,0,0,0]
["2020-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2020-06-01",2,53126.659999999996,1,2.46,0,0,0,0,0,0,0,0,1,53124.2]
["2020-07-01",5,15910.569975,1,4.0199999999999996,0,0,1,10.51,0,0,2,896.03997500000003,1,15000]
["2020-08-01",9,6107.7499999999991,1,4.55,1,6.9,1,24.87,1,79.53,2,415.77,3,5576.13]
["2020-09-01",5,1671.595,0,0,1,6.8849999999999998,0,0,0,0,2,362.69,2,1302.02]
["2020-10-01",17,{"$f":"E12+I12+M12+O12+G12+K12","v":6440.61},4,18.079999999999998,1,8.09,4,60.97,1,61.2,4,1290.27,3,5002]
["Notes - From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["$ indicates as on October 31, 2020"]
["Source: SEBI."]

{"sheet":"10","index":10,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,9,1,10],[13,0,13,8],[14,0,14,8],[15,0,15,8],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
["Table 10: Capital Raised by Listed Companies from the Primary Market through QIPs"]
["Year / Month","Only BSE",null,"Only NSE",null,"Only MSEI",null,"Both NSE and BSE",null,"Total"]
[null,"No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)"]
["2019-20",0,0,0,0,0,0,14,54388.924919999998,14,54388.924919999998]
["2020-21$",{"$f":"SUM(B6:B12)","v":0},0,0,0,0,0,{"$f":"SUM(H6:H12)","v":16},{"$f":"SUM(I6:I12)","v":56475.280000000006},16,56475.280000000006]
["Apr-20",0,0,0,0,0,0,0,0,0,0]
["May-20",0,0,0,0,0,0,0,0,0,0]
["Jun-20",0,0,0,0,0,0,2,8212.5,2,8212.5]
["Jul-20",0,0,0,0,0,0,1,2000,1,2000]
["Aug-20 *",0,0,0,0,0,0,7,42724.94,7,42724.94]
["2020-09-01",0,0,0,0,0,0,3,1337.87,3,1337.87]
["2020-10-01",0,0,0,0,0,0,3,2199.9699999999998,3,2199.9699999999998]
["Notes -"]
["$ indicates as on October 31, 2020"]
["* In the month of August 2020, the common amount on BSE and NSE includes warrants of HDFC Ltd of Rs. 3999.99 crs"]
["Source: BSE, NSE and MSEI."]

{"sheet":"11","index":11,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,9,1,10],[14,0,14,1],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
["Table 11: Preferential Allotments Listed at Stock Exchanges"]
["Year/Month","Only BSE",null,"Only NSE",null,"Only MSEI",null,"Both NSE and BSE",null,"Total"]
[null,"No. of  issues","Amount (` crore)","No. of  issues","Amount (` crore)","No. of  issues","Amount (`crore)","No. of  issues","Amount ` crore)","No. of issues","Amount (`crore)"]
["2019-20",130,1853.24,14,76.11,6,24.77,142,172970.61,282,174875.19]
["2020-21$",{"$f":"SUM(B6:B12)","v":62},504.73,6,49.56,3,20,61,18130.384022558999,{"$f":"SUM(J6:J12)","v":132},{"$f":"SUM(K6:K12)","v":18704.674022559}]
["Apr-20",15,119.45,0,0,1,2,7,986.95,{"$f":"B6+D6+F6+H6","v":23},1108.4000000000001]
["May-20",4,11.14,0,0,0,0,7,295.88,11,307.02]
["Jun-20",10,64.959999999999994,0,0,0,0,8,3967.7,18,4032.66]
["Jul-20",9,83.64,0,0,0,0,9,798.85,18,882.49]
["Aug-20",11,110.04,2,9,1,9,5,2617.62,19,2745.66]
["2020-09-01",8,52.41,2,10.46,1,9,10,7612.09,21,7683.96]
["2020-10-01",5,63.09,2,30.099999999999998,0,0,15,1851.2940225590003,22,1944.4840225590003]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"12","index":12,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,1],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
["Table 12: Private Placement of Corporate Debt Reported to Stock Exchanges"]
["Year/Month","Listed only on NSE",null,"Listed only on BSE",null,"Listed both Both NSE and BSE",null,"TOTAL"]
[null,"No. of Issues","Amount (`crore)","No. of Issues","Amount (` crore)","No. of Issues","Amount (` crore)","No. of Issues","Amount (` crore)"]
["2019-20",362,202997.40719999999,1272,254915.23230269999,152,216657.15400000001,1786,674670.6135027]
["2020-21$",{"$f":"SUM(B6:B12)","v":221},{"$f":"SUM(C6:C12)","v":104291.36},833,152984.77000000002,103,185250.81,1157,442526.07000000007]
["Apr-20",19,11880,40,15200,11,27559.1,70,54638.720000000001]
["May-20",33,21706,48,14911.19,26,47956.3,107,84573.49]
["Jun-20",43,18704,136,28221,9,23289,188,70213.5]
["Jul-20",40,17454.84,191,20187.64,12,10319.200000000001,243,47961.68]
["2020-08-01",26,5592.7,163,21144.71,24,31681.8,{"$f":"SUM(B10,D10,F10)","v":213},{"$f":"SUM(C10,E10,G10)","v":58419.21}]
["2020-09-01",34,12161.71,145,28999.54,10,23227.4,189,64388.65]
["2020-10-01",26,16792.11,110,24320.69,11,21218.01,147,62330.82]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE and NSE"]

{"sheet":"13","index":13,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Table 13: Trading in the Corporate Debt Market"]
["Year / Month","BSE",null,"NSE",null,"MSEI",null,"Total"]
[null,"No. of Trades","Traded Value (` crore)","No. of Trades","Traded Value (` crore)","No. of Trades","Traded Value (` crore)","No. of Trades","Traded Value (` crore)"]
["2019-20",57669,764268.62,80558,1463552.27,0,0,138227,2227820.96]
["2020-21$",{"$f":"SUM(B6:B12)","v":38134},{"$f":"SUM(C6:C12)","v":434369.31799999997},41930,801381.20199999993,0,0,{"$f":"SUM(H6:H12)","v":80064},{"$f":"SUM(I6:I12)","v":1235750.52}]
["Apr-20",3753,65285.07,5173,149229.69,0,0,{"$f":"B6+D6","v":8926},{"$f":"E6+C6","v":214514.76}]
["May-20",4677,64964.767999999996,6004,131841.63199999998,0,0,{"$f":"B7+D7","v":10681},{"$f":"E7+C7","v":196806.39999999997}]
["Jun-20",7231,76987.05,7647,130256.79,0,0,14878,207243.84]
["Jul-20",6813,80074.63,6710,121730.01,0,0,13523,201804.64]
["2020-08-01",4946,53915.519999999997,5200,89136.44,0,0,{"$f":"SUM(B10,D10,F10)","v":10146},{"$f":"SUM(C10,E10,G10)","v":143051.96}]
["2020-09-01",5695,50693.919999999998,5864,90782.64,0,0,11559,141476.56]
["2020-10-01",5019,42448.36,5332,88404.000000000015,0,0,10351,130852.36000000002]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE and NSE"]

{"sheet":"14","index":14,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,5],[15,0,15,5],[0,0,0,12],[1,0,2,0],[1,1,1,8],[1,9,2,10],[1,11,2,12],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8]]}
["Table 14: Ratings Assigned for Long-term Corporate Debt Securities (Maturity ≥ 1 year)"]
["Grade","Investment Grade",null,null,null,null,null,null,null,"Non-Investment Grade",null,"Total"]
[null,"Highest Safety (AAA)",null,"High Safety (AA)",null,"Adequate Safety (A)",null,"Moderate Safety (BBB)"]
["Period","No. of issue","Amount  (`crore)","No. of issue","Amount  (` crore)","No. of issue","Amount  (` crore)","No. of issue","Amount  (` crore)","No. of issue","Amount  (` crore)","No. of issue","Amount  (` crore)"]
["2019-20",315,1895046.59,308,194418.72,278,40357.379999999997,200,31405.884999999998,44,10059.959999999999,1145,2171738.5350000001]
["2020-21$",{"$f":"SUM(B7:B13)","v":169},{"$f":"SUM(C7:C13)","v":1352441.7900000003},272,226858.54000000004,166,31202.14,105,29185.19,30,5385.7000000000007,742,1645073.4400000002]
["Apr-20",25,540951.9,28,52120.9,11,5075,5,1630.19,2,535,71,600312.99]
["May-20",17,76524.42,38,19249.330000000002,21,5426.38,7,620,1,100,84,101920.13]
["Jun-20",30,49056.53,43,33536.160000000003,36,4757.08,27,19665.78,0,0,136,107015.55]
["Jul-20",23,115681.76,41,16437.48,22,2665.11,22,866.59,7,352,115,136003.01999999999]
["Aug-20",18,148303.47,24,25639.17,32,6989.12,17,3401.9,3,167,94,184500.66]
["2020-09-01",34,357648.64000000001,63,58608.86,34,5034.5200000000004,17,2227.8200000000002,7,2544.0500000000002,155,426063.89]
["Oct-20",22,64275.07,35,21266.639999999999,10,1254.93,10,772.91,10,1687.65,87,89257.2]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: Credit Rating Agencies."]

{"sheet":"15","index":15,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,12],[14,0,14,12],[0,0,0,12],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12]]}
["Table 15: Review of Accepted Ratings of Corporate Debt Securities (Maturity ≥ 1 year)"]
["Grade","Upgraded",null,"Downgraded",null,"Reaffirmed",null,"Rating Watch",null,"Withdrawn/ Suspended",null,"Total"]
["Period","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)"]
["2019-20",252,75088.09,1689,1854100.55,4425,9132486.0999999996,768,739873.1,1193,580065.56999999995,8184,12225936.51]
["2020-21$",{"$f":"SUM(B6:B12)","v":111},{"$f":"SUM(C6:C12)","v":62822.239999999998},571,255059.34999999998,3885,9470805.0140000004,169,118285.98,924,983110.06,5520,10715730.089]
["Apr-20",4,598.4,78,18083.34,335,1772609.63,46,24584.43,181,514291.99,644,2330167.7949999999]
["May-20",4,37.630000000000003,85,57246.42,493,1201121.33,29,40188.47,82,42963.5,689,1340951.46]
["Jun-15",9,2751.45,78,47594.14,700,1263013.22,16,13712.15,104,55701.22,889,1361302.26]
["Jul-20",6,138.13,61,11188,567,1234071.6499999999,9,3821.4,111,76813.8,737,1310780.67]
["Aug-20",21,7118.39,67,24674.93,612,1496279.868,15,5088.58,115,117215.56,803,1589777.4480000001]
["2020-09-01",38,51115,127,57497.39,832,1777440.6680000001,27,18424.75,189,97682.6,1186,1966397.2379999999]
["Oct-20",29,1063.24,75,38775.129999999997,346,726268.64800000004,27,12466.2,142,78441.39,572,816353.21799999999]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: Credit Rating Agencies."]

{"sheet":"16","index":16,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,4],[6,0,6,3],[7,0,7,3]]}
["Table 16: Distribution of Turnover on Cash Segments of Stock Exchanges (`crore)"]
["Stock Exchanges","Oct-20","2019-20","2020-21$"]
["BSE",57866.31,660896.02,520752.31]
["MSEI",0.64067499999999999,27.988247170000001,4.5524722500000001]
["NSE",1098883.7649999999,8998811.0710000005,8210229.4409999996]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"17","index":17,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,13,1,15],[13,0,13,7],[0,0,0,16],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[14,0,14,7],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12]]}
["Table 17: Trends in Cash Segment of BSE "]
["Year / Month","No. of Companies Listed ","No. of Companies Permitted","No. of companies traded ","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (` crore)","Average Daily Turnover (` crore)","Average Trade Size (`)","Demat Securities Traded (Lakh)","Demat Turnover (` crore)","Market  Capitalisation (` crore) ","S&P BSE Sensex "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
["2019-20",5377,36,4089,247,3247.6,573547.84,660896.02,2675.6923886640002,20350.290060351999,573547.84,660895.9,11348756.59,42273.87,25638.9,29468.49]
["2020-21$",{"$f":"B12","v":5437},28,3837,{"$f":"SUM(E6:E12)","v":146},2984.09,529487.26,{"$f":"SUM(H6:H12)","v":520752.31},{"$f":"H5/E5","v":3566.7966438356166},{"$f":"H5/F5*100","v":17450.958583688829},{"$f":"SUM(K6:K12)","v":529487.26},{"$f":"SUM(L6:L12)","v":520752.27999999997},{"$f":"M12","v":15792249.91},{"$f":"MAX(N6:N12)","v":41048.050000000003},{"$f":"MIN(O6:O12)","v":27500.79},{"$f":"P12","v":39614.07}]
["Apr-20",5380,36,3352,18,349.14,38886.06,44476.34,2470.9077779999998,12738.82683,38886.06,44476.34,12941620.82,33887.25,27500.79,33717.620000000003]
["May-20",5369,36,3303,19,314.3,50830.89,65018.99,3422.0521052630002,20686.920139993999,50830.89,65018.97,12706528.939999999,32845.480000000003,29968.45,32424.1]
["Jun-20",5377,28,3481,22,555.78,108236.37,110192.7,5008.7590909090004,19826.676022887001,108236.37,110192.67,13915689.83,35706.550000000003,32348.1,34915.800000000003]
["Jul-20",5399,27,3624,23,513.70000000000005,98513.1,80092.740000000005,3482.2930434780001,15591.34514308,98513.1,80092.73,14739115.83,38617.03,34927.199999999997,37606.89,0]
["Aug-20",5413,27,3605,21,484.21,99670,93079.96,4432.3790476189997,19223.056112017999,99670,93079.99,15376302.710000001,40010.17,36911.230000000003,38628.29]
["2020-09-01",5428,28,3587,22,402.69,78826.509999999995,70025.27,3182.9668181820002,17389.373960117999,78826.509999999995,70025.27,15524267.369999999,39359.51,36495.980000000003,38067.93]
["Oct-20",5437,28,3543,21,364.27,54524.33,57866.31,2755.5385714290001,15885.554670985999,54524.33,57866.31,15792249.91,41048.050000000003,38410.199999999997,39614.07]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE ."]

{"sheet":"18","index":18,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,12,2,12],[1,13,1,15],[13,0,13,7],[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[14,0,14,7],[15,0,15,7],[1,9,2,9],[1,10,2,10],[1,11,2,11]]}
["Table 18: Trends in Cash Segment of NSE "]
["Year / Month","No. of Companies Listed ","No. of Companies Permitted","No. of companies traded ","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (` crore)","Average Daily Turnover (` crore)","Average Trade Size (`)","Demat Securities Traded (Lakh)","Demat Turnover (` crore)","Market  Capitalisation (` crore) ","Nifty 50 Index "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
["2019-20",1949,18,1989,247,31459.712469999999,4674056.682,8998811.0710000005,36432.43348,28604.238130000002,4674056.682,8998811.0710000005,11243111.77,12430.5,7511.1,8597.75]
["2020-21$",{"$f":"B12","v":1959},22,1974,{"$f":"SUM(E6:E12)","v":146},25840.719360000003,4087219.4367000004,{"$f":"SUM(H6:H12)","v":8210229.443},{"$f":"H5/E5","v":56234.448239726029},{"$f":"H5/F5*100","v":31772.449244230324},{"$f":"SUM(K6:K12)","v":4087219.4367000004},{"$f":"SUM(L6:L12)","v":8210229.443},{"$f":"M12","v":15587902.939999999},{"$f":"MAX(N6:N12)","v":12025.45},{"$f":"MIN(O6:O12)","v":8055.8},{"$f":"P12","v":11642.4}]
["Apr-20",1949,18,1855,18,3606.19038,427307.91,905802.22,50322.345560000002,25117.98115,427307.91,905802.22,12738625.880000001,9889.0499999999993,8055.8,9859.9]
["May-20",1947,18,1854,19,3417.96702,493359.26549999998,1000456.48,52655.604209999998,29270.51297,493359.26549999998,1000456.48,12516959.59,9598.85,8806.75,9580.2999999999993]
["Jun-20",1944,18,1872,22,4304.0271700000003,845760.36840000004,1350680.7239999999,61394.57836,31381.788970000001,845760.36840000004,1350680.7239999999,13804601.48,10553.15,9544.35,10302.1]
["Jul-20",1941,18,1886,23,3950.4627099999998,667758.13970000006,1348520.9850000001,58631.347159999998,34135.77304,667758.13970000006,1348520.9850000001,14629658.609999999,11341.4,10299.6,11073.45]
["Aug-20",1943,18,1886,21,3783.65128,659450.22499999998,1282556.5349999999,61074.120699999999,33897.324030000003,659450.22499999998,1282556.5349999999,15234206.699999999,11794.25,10882.25,11387.5]
["Sep-20",1946,18,1892,22,3596.4906099999998,574785.84840000002,1223328.7339999999,55605.851519999997,34014.5121,574785.84840000002,1223328.7339999999,15304722.35,11618.1,10790.2,11247.55]
["Oct-20",1959,22,1908,21,3181.93019,418797.67969999998,1098883.7649999999,52327.798309999998,34535.131159999997,418797.67969999998,1098883.7649999999,15587902.939999999,12025.45,11347.05,11642.4]
["Notes -"]
["Turnover Data compiled for all markets except auction market"]
["$ indicates as on October 31, 2020"]
["Source: NSE"]

{"sheet":"19","index":19,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,11,2,11],[1,12,2,12],[1,13,1,15],[14,0,14,15],[15,0,15,15],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,4,2,4]]}
["Table 19: Trends in Cash Segment of MSEI"]
["Year/Month","No. of Companies Listed ","No. of Companies Permitted ","No. of Companies Traded","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (₹ crore)","Average Daily Turnover (₹ crore)","Average Trade Size (`)","Demat Securities Traded (Lakh)","Demat Turnover (₹ crore)","Market  Capitalisation (₹ crore) *","SX 50 Index "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
["2019-20",295,1256,15,247,7.4999999999999997E-3,12.98218,27.988247170000001,0.11331274199999999,373176.62893333298,15.349758233999999,20.30463782,11034810.51,24440.1,15102.84,17120.96]
["2020-21$",297,1255,5,146,2.3800000000000002E-3,1.2780800000000001,4.5524722500000001,3.1181317E-2,191280.346638655,0,0,15176584.51,23871.67,16065.53,23186.74]
["Apr-20",296,1257,3,18,1.2999999999999999E-4,0.19211,0.692056,3.8447556000000001E-2,532350.76923076902,0,0,12577219.92,19582.8,16065.53,19582.82]
["May-20",295,1257,0,19,0,0,0,0,0,0,0,12348176.5,18975.599999999999,17527.78,18975.599999999999]
["Jun-20",295,1256,3,22,1.8000000000000001E-4,0.19714000000000001,0.70960880000000004,3.2254945E-2,394227.11109999998,0,0,13487770.939999999,20692.27,19439.25,20394.990000000002]
["Jul-20",296,1257,1,23,6.9999999999999994E-5,5.91E-2,0.21276,9.2504349999999996E-3,303942.85710000002,0,0,14394821.939999999,22504.43,20643.12,22015.439999999999]
["Aug-20",297,1258,2,21,2.9E-4,0.32501000000000002,1.153661,5.4936237999999998E-2,397814.13793103403,0,0,14933471.630000001,23093.360000000001,21661.75,22609.56]
["2020-09-01",297,1260,4,22,1.1100000000000001E-3,0.32167000000000001,1.1437114500000001,5.1986883999999997E-2,103037.067567568,0,0,14948126.76,23068.57,21505,22386.29]
["Oct-20",297,1255,1,21,5.9999999999999995E-4,0.18304999999999999,0.64067499999999999,3.0508332999999999E-2,106779.16666666701,0,0,15176584.51,23871.67,22720.35,23186.74]
["Notes -"]
["* The data of the Market Capitalization provided in the Bulletin includes listed as well as permitted to trade companies"]
["$ indicates as on October 31, 2020"]
["Source: MSEI"]

{"sheet":"20","index":20,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,0,27,7],[28,0,28,7],[29,0,29,7],[0,0,0,7],[1,0,1,7],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,4,2,5],[2,6,2,7]]}
["Table 20: City-wise Distribution of Turnover on Cash Segments "]
["(Percentage share in Turnover)"]
["S.No","City","BSE",null,"NSE",null,"MSEI"]
[null,null,"2019-20","2020-10-01","2019-20","2020-10-01","2019-20","2020-10-01"]
[1,"Ahmedabad",2.2055113240000002,11.80478939,1.65,5.36,1.04,0]
[2,"Bengaluru",1.1804078,0.69408069800000005,3.22,2.1,0,0]
[3,"Vadodra",0.73076405899999997,0.54870983699999998,0.24,0.19,0,0]
[4,"Bhubneshwar",1.6662054999999999E-2,9.8914899999999993E-3,0,0,0,0]
[5,"Chennai",0.73378679199999997,0.72144335599999998,0.87,0.6,0,0]
[6,"Cochin/Ernakulum",8.0620224000000004E-2,7.5911571999999997E-2,0.7,0.65,0,0]
[7,"Coimbatore",2.5038392E-2,1.8044872E-2,0.05,0.05,0,0]
[8,"New Delhi",1.080805639,1.6915187890000001,5.92,5.24,48.72,50]
[9,"Guwahati",2.7876812000000001E-2,2.4174686000000001E-2,0,0,0,0]
[10,"Hyderabad",0.28056737300000001,0.124752979,3.13,3.6,0,0]
[11,"Indore",0.246330406,0.287359162,0.3,0.24,0,0]
[12,"Jaipur",0.49095509999999998,0.44295193599999999,0.3,0.26,0,0.56999999999999995]
[13,"Kanpur",0.25279658399999999,0.239408708,0.08,0.15,1.93,0]
[14,"Kolkata",3.4114442089999999,4.036966402,5.24,3.9,0,0]
[15,"Ludhiana",7.3506302999999995E-2,9.6610786000000004E-2,0.11,0.06,0,0]
[16,"Mangalore",1.3216734000000001E-2,9.6068530000000003E-3,0,0,0,0]
[17,"Mumbai",51.073666179999996,32.390740845000003,64.040000000000006,68.03,21.1,0]
[18,"Patna",3.3395598999999998E-2,1.5714822E-2,0,0,0,0]
[19,"Pune",0.26363530600000001,0.23107096399999999,0.08,0.11,0,0]
[20,"Rajkot",1.609832749,1.812279647,1.07,0.81,0,0]
[21,"Others",36.169180359999999,44.723972207000003,13,8.65,27.21,49.43]
[null,"Total",100,100,100,100,100,100]
["Notes -"]
["The city-wise distribution of turnover is based on the cities uploaded in the UCC database of the Exchange for clientele trades and members registered office city for proprietary trades."]
[]
["Source: BSE, NSE and MSEI."]

{"sheet":"21","index":21,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,2,0],[1,1,1,5],[13,0,13,4],[14,0,14,4]]}
["Table 21: Category-wise Share of Turnover in Cash Segment of BSE"]
["Year / Month","Percentage Share in Turnover"]
[null,"Proprietary","FPIs","Mutual Funds","Banks","Others"]
["2019-20",27.74,9.16,7.38,0.12,55.6]
["2020-21$",32.561428571,12.368571428999999,2.9471428569999998,4.7142857000000003E-2,52.071428570999998]
["Apr-20",38.65,9.98,2.74,0.01,48.61]
["May-20",28.1,22,5.33,0.02,44.54]
["Jun-20",27.04,24,2.89,0.01,46.06]
["Jul-20",36.619999999999997,3.13,2.2599999999999998,0.01,57.98]
["Aug-20",30.41,8.9700000000000006,1.91,0.1,58.61]
["2020-09-01",33.79,7.81,2.99,0.05,55.36]
["Oct-20",33.32,10.69,2.5099999999999998,0.14000000000000001,53.34]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE."]

{"sheet":"22","index":22,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,2,0],[1,1,1,5],[13,0,13,5],[14,0,14,5]]}
["Table 22: Category-wise Share of Turnover in Cash Segment of NSE"]
["Year /Month","Percentage Share in Turnover"]
[null,"Proprietary","FPIs","Mutual Funds","Banks","Others"]
["2019-20",22.46,10.68,5.27,0.1,61.48]
["2020-21$",23.6,10.73,5.16,0.09,60.42]
["Apr-20",22.68,13.45,6.19,0.06,57.62]
["May-20",21.62,13.44,6.17,0.05,58.72]
["Jun-20",23.22,9.32,5,0.17,62.29]
["Jul-20",21.67,8.16,4.6900000000000004,0.08,65.400000000000006]
["Aug-20",23.12,9.0500000000000007,4.3099999999999996,0.12,63.39]
["2020-09-01",26.6,10.38,4.84,0.09,58.1]
["Oct-20",26.32,11.29,4.92,7.0000000000000007E-2,57.4]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: NSE."]

{"sheet":"23","index":23,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5],[13,0,13,5],[14,0,14,5]]}
["Table 23: Category-wise Share of Turnover in Cash Segment of MSEI"]
["Year / Month","Percentage Share in Turnover"]
[null,"Proprietary","FPIs","Mutual Funds","Banks","Others"]
["2019-20",0,0,0,0,100]
["2020-21$",0,0,0,0,100]
["Apr-20",0,0,0,0,100]
["May-20",0,0,0,0,0]
["Jun-20",0,0,0,0,100]
["Jul-20",0,0,0,0,100]
["Aug-20",0,0,0,0,100]
["2020-09-01",0,0,0,0,100]
["Oct-20",0,0,0,0,100]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: MSEI."]

{"sheet":"24","index":24,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,9],[0,0,0,10],[32,0,32,9],[33,0,33,9],[34,0,34,9],[35,0,35,9],[36,0,36,9]]}
["Table 24: Component Stocks: S&P BSE Sensex during Oct-20"]
["Sl.No","Name of Security","Issued\nCapital \n(` crore)","Free Float\nMarket\nCapitalisation\n(` crore)","Weightage (per cent)","Beta","R2","Daily\nVolatility\n(per cent)","Monthly\nReturn\n(per cent)","Impact\nCost\n(per cent)"]
[1,"RELIANCE",6762.04,663526.93622000003,15.360932581,1.0900000000000001,0.591588,2.88,-8.0313370000000006,0.04]
[2,"HDFC BANK",550.52,481596.541868,11.149166081000001,1.06,0.722603,2.54,9.6599330000000005,0.15]
[3,"INFOSYS LTD",2129.71,391757.652887,9.0693573470000004,0.86,0.495807,2.4900000000000002,5.2182529999999998,0.34]
[4,"HDFC",359.16,344445.85732499999,7.9740690289999998,1.22,0.696434,2.98,10.547345999999999,0.26]
[5,"TCS LTD.",375.24,279987.208683,6.4818237229999998,0.73,0.41903099999999999,2.27,6.9576560000000001,0.05]
[6,"ICICI BANK",1379.37,270679.35880500003,6.2663430140000003,1.41,0.732433,3.33,10.608622,0.15]
[7,"KOTAK MAH.BK",989.7,202118.20664600001,4.6791229960000003,1.07,0.573909,2.88,22.036035999999999,0.04]
[8,"HIND UNI LT",234.96,184999.14064,4.2828092900000003,0.6,0.32553599999999999,2.12,0.190973,0.02]
[9,"ITC LTD.",1230.5,144368.32090799999,3.3421884230000001,0.65,0.29627599999999998,2.41,-3.78457,0.13]
[10,"AXIS BANK",612.03,129582.77886200001,2.9998967959999998,1.58,0.63432999999999995,4.03,15.995288,0.03]
[11,"LARSEN & TOU",280.81,111967.490298,2.5920953259999999,0.94,0.56729300000000005,2.52,3.0084759999999999,0.05]
[12,"BHARTI ARTL",2727.78,104083.298669,2.409572915,0.77,0.296819,2.86,3.0173429999999999,0.19]
[13,"ASIAN PAINTS",95.92,99769.397293000002,2.3097042509999999,0.7,0.41087699999999999,2.2000000000000002,11.345625999999999,0.16]
[14,"MARUTISUZUK",151.04,92458.471424000003,2.140453188,1.1100000000000001,0.57198800000000005,2.97,3.1640920000000001,0.15]
[15,"HCL TECHNO",542.73,91489.156224000006,2.1180131260000001,0.76,9.4152E-2,5.04,3.8935430000000002,0.05]
[16,"BAJFINANCE",120.52,87567.771317000006,2.0272313870000001,1.49,0.58631900000000003,3.94,0.92760600000000004,0.27]
[17,"STATE BANK",892.46,72626.065996999998,1.6813245139999999,1.1200000000000001,0.59264700000000003,2.95,2.0765910000000001,0.04]
[18,"NESTLE (I)",96.42,61226.435418000001,1.417418187,0.56000000000000005,0.30310100000000001,2.0699999999999998,7.7747140000000003,0.05]
[19,"MAH & MAH",621.6,56800.664567,1.3149596969999999,0.97,0.419713,3.03,-2.2710439999999998,0.05]
[20,"ULTRATECH CM",288.63,52803.085756,1.222414036,0.9,0.553817,2.4500000000000002,13.018285000000001,0.08]
[21,"SUN PHARMA.",239.93,50285.197102999999,1.1641238359999999,0.6,0.26110800000000001,2.4,-6.9430560000000003,0.19]
[22,"TECH MAH",483.48,50185.839314999997,1.1618236609999999,0.84,0.42698799999999998,2.59,2.7788300000000001,0.27]
[23,"TITAN",88.78,48606.549835999998,1.1252624339999999,0.87,0.45058700000000002,2.62,-2.9654310000000002,0.25]
[24,"POWER GRID",5231.59,43835.492610000001,1.0148104170000001,0.57999999999999996,0.29805599999999999,2.16,5.1660510000000004,0.18]
[25,"NTPC LTD",9894.56,42471.400758999996,0.98323110599999997,0.66,0.33265499999999998,2.31,2.8169010000000001,0.21]
[26,"BAJAJ AUTO",289.37,37586.081861999999,0.87013388300000005,0.8,0.46823900000000002,2.37,0.24136099999999999,0.05]
[27,"INDUSIND BNK",756.47,35302.588559999997,0.81727003600000003,1.68,0.399094,5.38,11.172281999999999,0.21]
[28,"BAJAJ FINSE",79.569999999999993,33702.227185000003,0.78022098500000003,1.36,0.62786399999999998,3.48,-4.7444879999999996,0.22]
[29,"TATA STEEL",1145.9000000000001,30049.760204999999,0.69566481099999999,1.04,0.47843200000000002,3.06,14.065322999999999,0.25]
[30,"ONGC CORPN",6290.14,23695.584510000001,0.54856292399999995,1.01,0.38712800000000003,3.28,-6.277056,0.23]
["Notes: 1. Beta & R2 are calculated for the trailing 12 months. Beta measures the  degree to which any portfolio of stocks is affected as compared to the effect on the market as a whole."]
["2. The coefficient of determination (R2) measures the strength of relationship between two variables the return on  a security versus that of the market."]
["3. Volatility is the standard deviation of the daily returns for the trailing 12 months."]
["4. Impact cost is calculated as the difference between actual buy price and ideal buy price, divided by ideal buy price, multiplied by 100. Hence ideal price is calculated as (best buy + best sell)/2."]
["5. The above is calculated for a month for the portfolio size of ` 5 lakh.  It is calculated for the current month."]
["Source: BSE."]

{"sheet":"25","index":25,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,0,57,9],[0,0,0,10],[52,0,52,9],[53,0,53,9],[54,0,54,9],[55,0,55,9],[56,0,56,9]]}
["Table 25: Component Stocks: Nifty 50 Index during Oct-20"]
["Sl. No","Name of Security","Issued\nCapital \n(`crore)","Free Float\nMarket\nCapitalisation\n(` crore)","Weightage (per cent)","Beta","R2","Daily\nVolatility\n(per cent)","Monthly\nReturn\n(per cent)","Impact\nCost\n(per cent)"]
[1,"Reliance Industries Ltd.",6339.41,664240.29,13.24,1.1299999999999999,0.57999999999999996,1.45,-8.0500000000000007,0.02]
[2,"HDFC Bank Ltd.",550.30999999999995,514544.86,10.25,1.07,0.69,1.92,9.73,0.02]
[3,"Infosys Ltd.",2129.6999999999998,388506.25,7.74,0.88,0.48,1.61,5.19,0.02]
[4,"Housing Development Finance Corporation Ltd.",358.26,344566.53,6.87,1.25,0.68,2.37,10.55,0.02]
[5,"Tata Consultancy Services Ltd.",375.24,279987.19,5.58,0.73,0.4,2.04,6.92,0.02]
[6,"ICICI Bank Ltd.",1379.2,270736.78999999998,5.4,1.43,0.72,2.39,10.67,0.03]
[7,"Kotak Mahindra Bank Ltd.",989.6,226634.34,4.5199999999999996,1.0900000000000001,0.55000000000000004,2.99,22.02,0.02]
[8,"Hindustan Unilever Ltd.",234.96,184932.16,3.69,0.63,0.33,1.04,0.15,0.02]
[9,"ITC Ltd.",1230.47,144368.32000000001,2.88,0.66,0.28999999999999998,1.1000000000000001,-3.76,0.03]
[10,"Axis Bank Ltd.",612.02,122074.46,2.4300000000000002,1.58,0.62,2.0099999999999998,15.98,0.03]
[11,"Larsen & Toubro Ltd.",280.81,113539.38,2.2599999999999998,0.95,0.56000000000000005,1.78,3.09,0.02]
[12,"Bharti Airtel Ltd.",2727.78,104119.31,2.08,0.77,0.28000000000000003,2.0299999999999998,3.04,0.03]
[13,"Asian Paints Ltd.",95.92,99699.5,1.99,0.71,0.4,1.9,11.33,0.02]
[14,"Maruti Suzuki India Ltd.",151.04,92577.45,1.85,1.1499999999999999,0.57999999999999996,1.38,3.29,0.02]
[15,"HCL Technologies Ltd.",542.73,91390.81,1.82,0.78,0.39,2.02,3.74,0.03]
[16,"Bajaj Finance Ltd.",120.52,87734.31,1.75,1.47,0.56000000000000005,2.48,0.93,0.02]
[17,"State Bank of India",892.46,72626.259999999995,1.45,1.1499999999999999,0.59,1.93,2.08,0.03]
[18,"Nestle India Ltd.",96.42,61221.97,1.22,0.6,0.32,1.93,7.81,0.03]
[19,"Dr. Reddy's Laboratories Ltd.",83.13,59331.66,1.18,0.48,0.18,1.1599999999999999,-5.77,0.02]
[20,"Mahindra & Mahindra Ltd.",621.6,56861.14,1.1299999999999999,1.02,0.43,1.67,-2.29,0.02]
[21,"UltraTech Cement Ltd.",288.63,52807.6,1.05,0.93,0.56000000000000005,1.56,12.95,0.03]
[22,"Wipro Ltd.",1142.9000000000001,50620.1,1.01,0.67,0.28999999999999998,2.89,8.66,0.03]
[23,"Tech Mahindra Ltd.",483.2,50302.42,1,0.87,0.44,2.02,2.72,0.03]
[24,"Sun Pharmaceutical Industries Ltd.",239.93,50287.06,1,0.64,0.27,1.54,-6.93,0.02]
[25,"Titan Company Ltd.",88.78,48642.03,0.97,0.88,0.44,1.53,-2.96,0.03]
[26,"HDFC Life Insurance Company Ltd.",2019.34,46445.25,0.93,1.07,0.53,1.2,5.43,0.02]
[27,"Power Grid Corporation of India Ltd.",5231.59,43835.49,0.87,0.6,0.3,1.56,5.26,0.03]
[28,"NTPC Ltd.",9894.56,42471.4,0.85,0.67,0.33,1.8,2.94,0.04]
[29,"Britannia Industries Ltd.",24.07,40968.910000000003,0.82,0.76,0.41,1.86,-8.5500000000000007,0.02]
[30,"Divi's Laboratories Ltd.",53.09,40037.550000000003,0.8,0.55000000000000004,0.23,1.72,3.09,0.03]
[31,"Cipla Ltd.",161.27000000000001,38327.85,0.76,0.47,0.14000000000000001,1.76,-2.61,0.03]
[32,"Bajaj Auto Ltd.",289.37,37591.81,0.75,0.81,0.45,2.0099999999999998,0.2,0.03]
[33,"Hero MotoCorp Ltd.",39.950000000000003,36351.82,0.72,0.88,0.39,2.14,-11.04,0.02]
[34,"Bajaj Finserv Ltd.",79.569999999999993,33704.160000000003,0.67,1.34,0.62,1.72,-4.76,0.03]
[35,"IndusInd Bank Ltd.",756.31,33222.949999999997,0.66,1.66,0.35,3.25,11.05,0.04]
[36,"Tata Steel Ltd.",1126.49,30986.18,0.62,1.1000000000000001,0.49,2.19,14.12,0.03]
[37,"Grasim Industries Ltd.",131.59,30725.91,0.61,1.1499999999999999,0.56999999999999995,1.35,4.59,0.03]
[38,"JSW Steel Ltd.",241.72,30623.77,0.61,1.3,0.62,2,11.25,0.03]
[39,"SBI Life Insurance Company Ltd.",1000.05,29998.240000000002,0.6,0.91,0.47,1.1599999999999999,-5.21,0.04]
[40,"Eicher Motors Ltd.",27.32,29061.22,0.57999999999999996,0.85,0.38,1.45,-5.32,0.02]
[41,"Shree Cement Ltd.",36.08,28961.96,0.57999999999999996,0.85,0.49,1.98,7.1,0.04]
[42,"Bharat Petroleum Corporation Ltd.",2169.25,28448.99,0.56999999999999995,1.07,0.41,1.73,0.4,0.03]
[43,"Adani Ports and Special Economic Zone Ltd.",406.35,26320.53,0.52,0.92,0.44,2.04,5.3,0.04]
[44,"UPL Ltd.",152.81,24933.86,0.5,1.0900000000000001,0.43,2.15,-9.8699999999999992,0.03]
[45,"Hindalco Industries Ltd.",224.63,24916.35,0.5,1.4,0.59,2.08,-2.62,0.03]
[46,"Coal India Ltd.",6162.73,23928.639999999999,0.48,0.65,0.25,1.65,-1.55,0.04]
[47,"Tata Motors Ltd.",617.79,23765.64,0.47,1.27,0.43,2.4300000000000002,-0.49,0.03]
[48,"Oil & Natural Gas Corporation Ltd.",6290.14,23677.34,0.47,1.02,0.36,1.81,-6.28,0.04]
[49,"Indian Oil Corporation Ltd.",9414.16,20220.2,0.4,0.72,0.4,1.3,7.65,0.04]
[50,"GAIL (India) Ltd.",4510.1400000000003,15671.62,0.31,0.79,0.28000000000000003,1.83,-2.36,0.04]
["Notes: 1. Beta & R2 are calculated for the the trailing 12 months. Beta measures the  degree to which any portfolio of stocks is affected as compared to the effect on the market as a whole."]
["2. The coefficient of determination (R2) measures the strength of relationship between two variables the return on  a security versus that of the market."]
["3. Volatility is the standard deviation of the daily returns for the the trailing 12 months."]
["4. Impact cost is calculated as the difference between actual buy price and ideal buy price, divided by ideal buy price, multiplied by 100. Hence ideal price is calculated as (best buy + best sell)/2."]
["5. Impact Cost for Nifty 50 is for a portfolio of Rs. 50 lakhs  and is weightage average impact cost."]
["Source: NSE."]

{"sheet":"26","index":26,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,0,47,10],[0,0,0,1],[42,0,42,10],[43,0,43,10],[44,0,44,10],[45,0,45,10],[46,0,46,10]]}
["Table 26: Component Stocks: SX40 Index"]
["S.No.","Name of Security","Issued Capital     (₹ crore)","Free Float Market Capitalisation (₹ crore)","Weightage (per cent)   ","Beta","R2","Daily Volatility (per cent)","Monthly Return (per cent)","Impact Cost (per cent) *"]
[1,"RELIANCE",6339.4107199999999,686190.64156615001,14.51,1.1399999999999999,0.59,0,0,"Na"]
[2,"HDFCBANK",550.25922909999997,491645.87702150003,10.4,1.07,0.69,0,0,"Na"]
[3,"INFY",2183.18462,414017.72614059999,8.75,0.9,0.49,0,0,"Na"]
[4,"HDFC",347.780708,319976.09783808002,6.77,1.25,0.68,0,0,"Na"]
[5,"TCS",375.23847060000003,288004.38219356001,6.09,0.74,0.41,0,0,"Na"]
[6,"ICICIBANK",1379.3407236,259253.74296405999,5.48,1.42,0.72,0,0,"Na"]
[7,"KOTAKBANK",989.69722750000005,211974.37718993999,4.4800000000000004,1.08,0.55000000000000004,0,0,"Na"]
[8,"HINDUNILVR",234.9556255,191051.99772119999,4.04,0.63,0.33,0,0,"Na"]
[9,"ITC",1230.2998192,147858.54992995001,3.13,0.66,0.28000000000000003,0,0,"Na"]
[10,"AXISBANK",611.93996679999998,123416.36891,2.61,1.57,0.61,0,0,"Na"]
[11,"LT",280.75420439999999,116471.062565,2.46,0.94,0.55000000000000004,0,0,"Na"]
[12,"BHARTIARTL",2727.7786775,106632.393030875,2.25,0.77,0.28000000000000003,0,0,"Na"]
[13,"ASIANPAINT",95.919779000000005,103186.27301145,2.1800000000000002,0.7,0.39,0,0,"Na"]
[14,"MARUTI",151.04003,94795.023542114999,2,1.1499999999999999,0.56999999999999995,0,0,"Na"]
[15,"HCLTECH",542.73301919999994,93391.24029894,1.97,0.79,0.4,0,0,"Na"]
[16,"BAJFINANCE",120.5099678,83345.042074500001,1.76,1.45,0.55000000000000004,0,0,"Na"]
[17,"SBIN",892.46115339999994,69360.218924775007,1.47,1.1499999999999999,0.57999999999999996,0,0,"Na"]
[18,"DRREDDY",85.668571499999999,63719.878929525003,1.35,0.48,0.18,0,0,"Na"]
[19,"NESTLEIND",96.415716000000003,63485.69750848,1.34,0.6,0.32,0,0,"Na"]
[20,"M&M",621.596272,58598.100653399997,1.24,1.02,0.42,0,0,"Na"]
[21,"ULTRACEMCO",288.629571,54256.119577010002,1.1499999999999999,0.93,0.55000000000000004,0,0,"Na"]
[22,"TECHM",493.70444250000003,53692.863535949997,1.1399999999999999,0.87,0.44,0,0,"Na"]
[23,"SUNPHARMA",239.92753300000001,52174.058663025004,1.1000000000000001,0.64,0.27,0,0,"Na"]
[24,"WIPRO",1142.993271,51332.402054780003,1.0900000000000001,0.68,0.28999999999999998,0,0,"Na"]
[25,"TITAN",88.778616,50220.980380125002,1.06,0.88,0.44,0,0,"Na"]
[26,"POWERGRID",5231.5896480000001,44856.175211100002,0.95,0.59,0.28999999999999998,0,0,"Na"]
[27,"NTPC",9894.5572800000009,43746.638144639997,0.92,0.66,0.32,0,0,"Na"]
[28,"BRITANNIA",24.072562999999999,42579.393173625002,0.9,0.75,0.4,0,0,"Na"]
[29,"INDUSINDBK",756.467893,37240.120662219997,0.79,1.65,0.34,0,0,"Na"]
[30,"HEROMOTOCO",39.949904600000004,37593.451041679997,0.79,0.88,0.39,0,0,"Na"]
[31,"BAJAJ-AUTO",289.36702000000002,35890.320427350001,0.76,0.81,0.45,0,0,"Na"]
[32,"TATASTEEL",1126.4923739999999,31773.59244507,0.67,1.1000000000000001,0.49,0,0,"Na"]
[33,"GRASIM",131.5856436,31417.388906655,0.66,1.1499999999999999,0.56000000000000005,0,0,"Na"]
[34,"BPCL",2169.2140439999998,29181.864140264999,0.62,1.07,0.41,0,0,"Na"]
[35,"ADANIPORTS",406.35035219999997,27445.184819549999,0.57999999999999996,0.91,0.44,0,0,"Na"]
[36,"HINDALCO",224.63525809999999,25709.123376615,0.54,1.39,0.57999999999999996,0,0,"Na"]
[37,"COALINDIA",6162.7283269999998,24507.209511500001,0.52,0.64,0.25,0,0,"Na"]
[38,"ONGC",6290.1396029999996,24645.827744229999,0.52,1.02,0.35,0,0,"Na"]
[39,"TATAMOTORS",617.79477880000002,24322.172259210001,0.51,1.26,0.43,0,0,"Na"]
[40,"IOC",9414.1589220000005,20486.831975130001,0.43,0.71,0.4,0,0,"Na"]
["Notes:"]
["1. Market Cap, Beta & R2 as on the last day of the month"]
["2. Beta & R2 are calculated for the trailing 12 months"]
["3. Volatility for the current month"]
["4. *Since there is no trading in the SX40 constituents, the Impact Cost for the given stocks is NiL."]
["Source: MSEI."]

{"sheet":"27","index":27,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,7,1,9],[12,0,12,5],[13,0,13,5],[14,0,14,5],[0,0,0,6],[1,0,2,0],[1,1,1,3],[1,4,1,6]]}
["Table 27: Advances/Declines in Cash Segment "]
["Year/ Month","BSE",null,null,"NSE",null,null,"MSEI"]
[null,"Advances","Declines","Advance/Decline Ratio","Advances","Declines","Advance/Decline Ratio","Advances","Declines","Advance/Decline Ratio"]
["2019-20",793,3134,0.25303126999999997,440,1530,0.28999999999999998,6,3,2]
["2020-21$",1163,2594,0.44834232800000001,578,1365,0.42,0,1,0]
["Apr-20",1291,1932,0.66821946200000004,825,1094,0.75,0,0,0]
["May-20",1410,1780,0.79213483100000004,914,977,0.94,0,0,0]
["Jun-20",2699,585,4.6136752139999997,1753,147,11.93,0,0,0]
["Jul-20",2243,1240,1.8088709679999999,1387,530,2.62,0,0,0]
["Aug-20",2322,1232,1.8847402600000001,1457,496,2.94,0,0,0]
["2020-09-01",1727,1821,0.94838001100000002,899,1056,0.85,0,0,0]
["Oct-20",1419,2095,0.677326969,777,1189,0.65,0,0,0]
["Notes:  Advance/Decline is calculated based on the average price methodology.                                                                           "]
["$ indicates as on October 31, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"28","index":28,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,7,1,9],[13,0,13,6],[14,0,14,6],[0,0,0,6],[1,0,2,0],[1,1,1,3],[1,4,1,6]]}
["Table 28: Trading Frequency in Cash Segment of Exchanges"]
["Month","BSE",null,null,"NSE",null,null,"MSEI"]
[null,"No. of Companies Listed","No. of Companies Traded","Traded to Listed (per cent)","No. of Companies Listed","No. of Companies Traded","Traded to Listed (per cent)","No. of Companies Listed","No. of Companies Traded","Traded to Listed (per cent)"]
["2019-20",5377,4089,76.046122373070489,1949,1989,102.05233453052847,295,15,5.0847457627118651]
["2020-21$",5437,3837,70.572006621298513,1959,1974,100.7656967840735,297,5,1.6835016835016834]
["Apr-20",5380,3352,62.304832713754642,1949,1855,95.177013853258089,296,3,1.0135135135135136]
["May-20",5369,3303,61.519836096107284,1947,1854,95.223420647149453,295,0,0]
["Jun-20",5377,3481,64.738701878370847,1944,1872,96.296296296296291,295,3,1.0169491525423728]
["Jul-20",5399,3624,33.561770698277456,1941,1886,97.166409067490989,296,1,0.33783783783783783]
["Aug-20",5413,3605,66.598928505449834,1943,1886,97.066392177045799,297,2,0.67340067340067333]
["2020-09-01",5428,3587,66.083271923360357,1946,1892,97.225077081192197,297,4,1.3468013468013467]
["Oct-20",5437,3543,65.16461283796211,1959,1908,97.396630934150068,297,1,0.33670033670033667]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"29","index":29,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,0,12,6],[13,0,13,6],[14,0,14,6]]}
["Table 29: Daily Volatility of Major Indices"]
[null,null,null,null,null,null,null,"(per cent)"]
["Year / Month","BSE Sensex","BSE 100","BSE 500","Nifty 50","Nifty Next 50","Nifty 500","SX40"]
["2019-20",1.77,1.74,1.7,1.7456697859999999,1.6196834090000001,1.6847958089999999,1.71]
["2020-21$",1.6051694910000001,1.5117267299999999,1.4335660109999999,1.558385133,1.273840603,1.424367106,1.57]
["Apr-20",3.03,2.81,2.6,2.8437730370000001,1.971064465,2.5081819959999998,3.01]
["May-20",2.15,2.04,1.91,2.048551588,1.6476503140000001,1.852370831,2.0499999999999998]
["Jun-20",1.25,1.18,1.1499999999999999,1.2171892010000001,0.945600102,1.1310003790000001,1.21]
["Jul-20",0.97,0.88,0.82,0.92596389499999998,0.67255359400000003,0.80530851699999995,0.93]
["Aug-20",0.99,0.94,0.93,0.92569446200000005,1.101700468,0.91958686099999998,0.93]
["2020-09-01",1.1963697230000001,1.2295098019999999,1.2543283540000001,1.1696402370000001,1.353955553,1.2230164509999999,1.19]
["Oct-20",1.0282128479999999,0.93340800000000002,0.85826741699999998,0.94172470799999997,0.73736095300000004,0.835326122,0.98]
["Notes: Volatility is calculated as the standard deviation of the natural log of daily returns in indices for the respective period."]
["$ indicates as on October 31, 2020"]
["Source: BSE, MSEI and NSE."]

{"sheet":"30","index":30,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,0,25,10],[0,0,0,10],[1,1,1,5],[1,6,1,10],[1,11,1,15],[3,0,3,15],[13,0,13,15],[23,0,23,10],[24,0,24,10]]}
["Table 30: Percentage Share of Top ‘N’ Securities/Members in Turnover of Cash Segment of Exchanges (per cent)"]
["Year/ Month","BSE",null,null,null,null,"NSE",null,null,null,null,"MSEI"]
["Top","5","10","25","50","100","5","10","25","50","100","5","10","25","50","100"]
["Securities"]
["2019-20",15.961600000000001,24.4329,39.517400000000002,52.518500000000003,68.082899999999995,15.55,26.32,45.68,60.58,77.92,97.15,99.99,100,100,100]
["2020-21$",18.704899999999999,28.768599999999999,44.421399999999998,56.766500000000001,71.163399999999996,19.170000000000002,29.27,47.33,63.39,79.63,100,100,100,100,100]
["Apr-20",18.805700000000002,29.1358,45.223100000000002,60.204700000000003,76.281199999999998,21.74,34.01,53.29,68.599999999999994,84.6,100,100,100,100,100]
["May-20",41.5822,51.138599999999997,63.966799999999999,74.109499999999997,84.837299999999999,24.02,36.799999999999997,53.22,69.14,85.35,0,0,0,0,0]
["Jun-20",33.7851,44.357500000000002,58.000900000000001,68.317999999999998,79.692300000000003,20.48,31.24,49.55,64.86,81.069999999999993,100,100,100,100,100]
["Jul-20",18.940300000000001,27.986699999999999,43.064300000000003,56.372599999999998,70.902100000000004,24.22,34.54,50.06,65.400000000000006,80.58,100,100,100,100,100]
["Aug-20",23.159199999999998,30.7546,42.8767,54.628799999999998,68.464500000000001,16.95,26.42,42.83,58.74,75.290000000000006,100,100,100,100,100]
["2020-09-01",15.774100000000001,23.506799999999998,38.415900000000001,52.5471,69.154799999999994,18.53,27.89,46.55,62.92,78.819999999999993,100,100,100,100,100]
["Oct-20",15.1569,24.3018,42.322899999999997,56.286900000000003,72.004099999999994,17.100000000000001,27.87,48.87,64.83,81.760000000000005,100,100,100,100,100]
["Members"]
["2019-20",26.49,40.159999999999997,64.55,76.040000000000006,85.83,25.48,39.020000000000003,59.55,75.87,87.66,80.36,100,100,100,100]
["2020-21$",34.4,50.11,70.010000000000005,81.14,89.33,31.03,44.26,63.74,78.650000000000006,89.4,100,100,100,100,0]
["Apr-20",32.94,49.91,71.44,82.7,91.2,30.67,44.88,65.510000000000005,80.709999999999994,90.92,100,100,100,100,0]
["May-20",42.92,56.43,76.25,85.01,91.92,30.67,44.2,64.59,80.209999999999994,90.67,0,0,0,0,0]
["Jun-20",45.78,60.7,77.42,85.46,92.1,30.73,45.25,64.84,78.89,89.48,100,100,100,100,0]
["Jul-20",40.35,55.93,71.569999999999993,80.84,88.93,32.21,45.3,64.28,77.55,88.45,100,100,100,100,0]
["Aug-20",32.85,46.38,68.19,79.760000000000005,88.9,31.57,44.29,63.23,77.44,88.4,100,100,100,100,0]
["2020-09-01",35.65,50.01,70.849999999999994,81.849999999999994,90.23,31.67,45.84,65.91,79.739999999999995,89.92,100,100,100,100,0]
["Oct-20",39.700000000000003,53.61,71.06,80.39,88.93,31.18,45.15,64.98,79.849999999999994,90.41,100,100,100,100,0]
["Notes: 1. Data for Top N scrips has been compiled for all markets except auction market & retail debt market and includes series EQ, BE,BT, BL and IL."]
["$ indicates as on October 31, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"31","index":31,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,8],[12,0,12,3]]}
["Table 31: Settlement Statistics for Cash Segment of ICCL"]
["Year /  Month","No. of Trades(lakh)","Traded Quantity   (lakh)","Delivered Quantity   (lakh)","Delivered Quantity to Traded Quantity (per cent)","Turnover (` crore)","Delivered Value   (` crore)","Delivered Value to Total Turnover (per cent)","Delivered Quantity in Demat Mode (lakh)","Demat Delivered Quantity to Total Delivered Quantity (per cent)","Delivered Value in Demat Mode     (` crore)","Demat Delivered Value to Total Delivered Value (per cent)","Short Delivery (Auctioned quantity) (lakh)","Short Delivery to Delivery Quantity (per cent)","Funds Pay-in (` crore)","Securities Pay-in (` crore)","Settlement Guarantee Fund (`crore)"]
["2019-20",3210.1607600000002,555304,204312.50842,35.861057875,672464.22,193663.12298489001,29.292300591,171221.4999,94.463028816000005,193243.43338827,99.819526788000005,369.15190000000001,0.21803175499999999,61952.6980559,193935.17293415,223.1]
["2020-21$",{"$f":"SUM(B5:B11)","v":2959.2},{"$f":"SUM(C5:C11)","v":525595.6},{"$f":"SUM(D5:D11)","v":148793.19138},{"$f":"D4/C4*100","v":28.309443872817813},{"$f":"SUM(F5:F11)","v":516548},{"$f":"SUM(G5:G11)","v":138130.31442000001},{"$f":"G4/F4*100","v":26.741041378535975},{"$f":"SUM(I5:I11)","v":148793.21137999996},{"$f":"I4/D4*100","v":100.00001344147522},{"$f":"SUM(K5:K11)","v":138130.31442000001},{"$f":"K4/G4*100","v":100},{"$f":"SUM(M5:M11)","v":375.57032999999996},{"$f":"M4/D4*100","v":0.25241096485445913},{"$f":"SUM(O5:O11)","v":31053},{"$f":"SUM(P5:P11)","v":138311},{"$f":"Q11","v":232.51}]
["Apr-20",339,37309,11926.5,31.97,44040,13145,29.85,11926.5,100,13145,100,30.3,0.25,3609,13162,224.38]
["May-20",316.2,46869,14976.3,31.953530052000001,63127,14218,22.522850761000001,14976.3,100,14218,100,30.3,0.20231966500000001,4598,14230,225.71]
["Jun-20",543.20000000000005,108007.6,28084.9,26,109738,22839,20.81,28084.9,100,22839,100,59.4,0.21,5227,22864,115.15]
["Jul-20",518.29999999999995,100445,30648.58,30.51,80053,23567,29.44,30648.6,100,23567,100,134.4,0.44,4656,23596,228.38]
["Aug-20",471.9,93649,27994.7,29.89,90938,25780,28.35,27994.7,100,25780,100,45.8,0.16,4505,25812,229.69]
["2020-09-01",427.4,87230,20728.811379999999,23.7633972,73748,21778.314419999999,29.53071869,20728.811379999999,100,21778.314419999999,100,31.470330000000001,0.15181926900000001,4968,21819,231.16]
["Oct-20",343.2,52086,14433.4,27.710709212000001,54904,16803,30.604327554000001,14433.4,100,16803,100,43.9,0.30415563899999998,3490,16828,232.51]
["Notes -"]
["$ indicates as on October 31, 2020"]

{"sheet":"32","index":32,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,8],[11,0,11,6],[12,0,12,6],[13,0,13,6]]}
["Table 32: Settlement Statistics for Cash Segment of NSCCL"]
["Year /  Month","No. of Trades(lakh)","Traded Quantity   (lakh)","Delivered Quantity   (lakh)","Delivered Quantity to Traded Quantity (per cent)","Turnover (` crore)","Delivered Value   (` crore)","Delivered Value to Total Turnover (per cent)","Delivered Quantity in Demat Mode (lakh)","Demat Delivered Quantity to Total Delivered Quantity (per cent)","Delivered Value in Demat Mode     (` crore)","Demat Delivered Value to Total Delivered Value (per cent)","Short Delivery (Auctioned quantity) (lakh)","Short Delivery to Delivery Quantity (per cent)","Funds Pay-in (` crore)","Securities Pay-in (` crore)","Settlement Guarantee Fund (`crore)"]
["2019-20",35768.935709999998,5361647.5389999999,1067585.125,19.911512590000001,9643316.7670000009,2077333.0319999999,21.54168615,1065619.0109999999,100,2075912.925,100,1966.104961,0.18450355500000001,600587.1226,2077333.0319999999,302.11]
["2020-21$",{"$f":"SUM(B5:B11)","v":30866.567049999998},{"$f":"SUM(C5:C11)","v":4849259.1338999998},811558.2479800001,{"$f":"D4/C4*100","v":16.735716231508281},8746592.7699999996,1504538.5083999999,{"$f":"G4/F4*100","v":17.201424005475907},809750.22905999993,{"$f":"I4/D4*100","v":99.777216370543897},1503542.5223999999,{"$f":"K4/G4*100","v":99.933801229118473},1808.0190400000001,{"$f":"M4/D4*100","v":0.22278364424244712},433674.51000000007,1504538.5083999999,{"$f":"Q11","v":329.18}]
["Apr-20",4150.2334300000002,468098.45819999999,86142.43144,18.40263088,926064.65599999996,169258.2064,18.277147849999999,85960.241169999994,100,169154.07440000001,100,182.19027,0.21194713700000001,53768.75,169258.2064,305.51]
["May-20",3967.3101900000001,519841.9523,90797.839619999999,17.466431709999998,1049727.142,201623.16380000001,19.207197359999999,90650.955839999995,100,201524.13329999999,100,146.88378,0.16177012599999999,80224.740000000005,201623.16380000001,311.04000000000002]
["Jun-20",5341.7662899999996,1030660.0110000001,155158.89689999999,15.054323950000001,1520003.977,249841.2941,16.43688423,154762.5999,100,249657.12940000001,100,396.29710999999998,0.25606775199999998,75290.960000000006,249841.2941,314.77999999999997]
["Jul-20",4814.26847,805230.80790000001,131916.69380000001,16.382469780000001,1414639.284,229927.28049999999,16.25342114,131411.98749999999,100,229766.37590000001,100,504.70627999999999,0.38259473900000002,56586.18,229927.28049999999,316.97000000000003]
["Aug-20",4483.88429,756614.81169999996,138718.49950000001,18.334097799999999,1339265.102,229893.01019999999,17.165608949999999,138575.89129999999,100,229745.5386,100,142.60824,0.10280405300000001,55195.16,229893.01019999999,320.88]
["Sep-20",4506.4092099999998,781188.5871,123886.25689999999,15.858687509999999,1386253.895,235653.72029999999,16.999318890000001,123617.95080000001,100,235469.04939999999,100,268.30608999999998,0.217044603,64749.96,235653.72029999999,326.93]
["Oct-20",3602.69517,487624.50569999998,84937.629820000002,17.418654889999999,1110638.7139999999,188341.83309999999,16.957974790000002,84770.602549999996,100,188226.22140000001,100,167.02726999999999,0.19664696400000001,47858.76,188341.83309999999,329.18]
["Notes - Settlement Statistics for settlement type N, excluding CM Series IL & BL"]
["$ indicates as on October 31, 2020"]
["Source: NSCCL"]

{"sheet":"33","index":33,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,14],[13,0,13,14]]}
["Table 33: Settlement Statistics for Cash Segment of MCCIL"]
["Month Sorting","No. of Trades(Lakh)","Traded Quantity (Lakh)","Delivered Quantity   (Lakh)","Delivered Quantity to Traded Quantity (per cent)","Turnover (₹ crore)","Delivered Value      (₹ crore)","Delivered Value to Total Turnover (per cent)","Delivered Quantity in Demat Mode (Lakh)","Demat Delivered Quantity to Total Delivered Quantity (per cent)","Delivered Value in Demat Mode     (₹ crore)","Demat Delivered Value to Total Delivered Value (per cent)","Funds Pay-in (₹ crore)","Securities Pay-in (₹ crore)","Settlement Guarantee Fund(₹ crore)"]
["2019-20",5.64E-3,10.29321,10.291169999999999,99.98,20.302788339999999,20.301970449999999,100,10.291169999999999,100,20.301970449999999,100,20.301970449999999,20.301970449999999,0.35]
["2020-21$",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Apr-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["May-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Jun-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Jul-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Aug-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Sep-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Oct-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: MCCIL"]

{"sheet":"34","index":34,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,9],[0,0,0,17],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,2,5],[1,6,1,9],[1,10,1,13],[1,14,2,15],[1,16,2,17],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[13,0,13,9],[14,0,14,9]]}
["Table 34: Trends in Equity Derivatives Segment at BSE (Turnover in Notional Value) "]
["Year/     Month","No. of Trading Days","Index Futures",null,"Stock Futures",null,"Index Options",null,null,null,"Stock Options",null,null,null,"Total",null,"Open Interest at the end of Month"]
[null,null,null,null,null,null,"Call",null,"Put",null,"Call",null,"Put"]
[null,null,"No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\ncontracts","Turnover\n(` crore)"]
["2019-20",247,150212,14933.63792825,2983,162.96255754500001,2032161,200440.05508463,480178,45522.520567375002,8473,626.10800537499995,7876,583.24307475000001,2681883,262268.51721791999,515,37.94]
["2020-21$",{"$f":"SUM(B7:B13)","v":146},36988,3236.6351696249999,0,0,54973222,5273598.9565901002,43689654,3519927.2630694704,0,0,0,0,98699864,8796762.8448291998,{"$f":"Q13","v":3842},{"$f":"R13","v":351.4300452}]
["Apr-20",18,962,77.77,0,0,995903,87578.38,309028,21493.72,0,0,0,0,1305893,109149.87,2407,202.9]
["May-20",19,4144,326.38,0,0,1218595,107799.6,142492,9623.57,0,0,0,0,1365231,117749.55,971,78.709999999999994]
["Jun-20",22,1747,145.84,0,0,106,8.98,0,0,0,0,0,0,1853,154.82,81,6.54]
["Jul-20",23,7735,663.89,0,0,3256827,297616.75,3893948,304232.15000000002,0,0,0,0,7158510,602512.78,4045,352.49]
["Aug-20",21,6025,536.5,0,0,11023986,1047508,10361093,800072.42,0,0,0,0,21391104,1848116.92,8217,735.07]
["2020-09-01",22,8832,786.64434974999995,0,0,20820481,1992957.1291642999,8975662,732822.87558186997,0,0,0,0,29804975,2726566.6490958999,3589,318.18584564999998]
["Oct-20",21,7543,699.61081987499995,0,0,17657324,1740130.1174258001,20007431,1651682.5274876,0,0,0,0,37672298,3392512.2557333,3842,351.4300452]
["Notes: 1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on October 31, 2020"]
["Source: BSE."]

{"sheet":"35","index":35,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,2,5],[1,6,1,9],[1,10,1,13],[13,0,13,17],[14,0,14,17],[15,0,15,17],[1,14,2,15],[1,16,2,17],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13]]}
["Table 35: Trends in Equity Derivatives Segment at NSE (Turnover in Notional Value) "]
["Year/     Month","No. of Trading Days","Index Futures",null,"Stock Futures",null,"Index Options",null,null,null,"Stock Options",null,null,null,"Total",null,"Open Interest at the end of Month"]
[null,null,null,null,null,null,"Call",null,"Put",null,"Call",null,"Put"]
[null,null,"No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)","No. of\nContracts","Turnover\n(` crore)"]
["2019-20",247,94472538,6677312.0489999996,256643910,14874729.23,2480471005,169696653.69999999,2095899292,140995315.59999999,125587962,8003236.6960000005,72247170,4285644.5180000002,5125321877,344532891.80000001,3162958,163121.89000000001]
["2020-21$",{"$f":"SUM(B7:B13)","v":146},82438538,4973223.8791000005,151625724,9562983.0076000001,2101461716,129895917.24000001,1865387822,112324151.75899999,108691764,8024469.1224000007,53753471,3545565.4204000002,4363359035,268326310.43000004,{"$f":"Q13","v":4190150},{"$f":"R13","v":306997.98}]
["Apr-20",18,11339332,594715.51879999996,19476580,954968.99560000002,194547845,10077297.859999999,170934639,8385702.6540000001,8039630,446624.89990000002,4593986,224068.50750000001,408932012,20683378.43,2874264,170257.67]
["May-20",19,12843909,640625.01850000001,22573353,1118023.5830000001,247931778,12205317.18,211059297,9947263.2349999994,10850597,613231.52850000001,6115405,307470.4877,511374339,24831931.030000001,3707494,207782.64]
["Jun-20",22,15478384,859740.79729999998,26276560,1455365.7320000001,315751153,17914117.940000001,274665301,14986695.93,16288049,1004821.518,8934064,489038.42219999997,657393511,36709780.340000004,4366903,287861.11]
["Jul-20",23,11772248,777191.33360000001,22710216,1574937.3559999999,352353120,21236714.829999998,306566670,18239374.289999999,18843923,1466518.213,8956614,640972.45660000003,721202791,43935708.490000002,4086465,295273.53000000003]
["Aug-20",21,9211071,621182.59080000001,20582172,1478175.953,272955256,18650461.920000002,248776124,16724302.85,17535138,1370741.004,8110037,584505.17619999999,577169798,39429369.490000002,4589201,340564.43]
["Sep-20",22,11161701,740669.28419999999,20622408,1535447.6340000001,335641868,22765319.579999998,306427676,20183965.609999999,18581654,1577042.183,8457379,652074.08499999996,700892686,47454518.380000003,5135777,370433.46]
["Oct-20",21,10631893,739099.33589999995,19384435,1446063.754,382280696,27046687.93,346958115,23856847.190000001,18552773,1545489.7760000001,8585986,647436.28520000004,786393898,55281624.270000003,4190150,306997.98]
["Notes: 1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on October 31, 2020"]
["Source: NSE."]

{"sheet":"36","index":36,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,11,4,11],[3,12,4,12],[15,0,15,3],[16,0,16,3],[0,0,0,12],[2,0,4,0],[2,1,2,6],[2,7,2,12],[3,1,3,2],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,3,8],[3,9,3,10]]}
["Table 36: Settlement Statistics in Equity Derivatives Segment "]
[null,null,null,null,null,null,null,null,null,null,null,null," (` crore)"]
["Year/     Month","BSE",null,null,null,null,null,"NSE"]
[null,"Index/Stock\nFutures",null,"Index/Stock\nOptions",null,"Total","Settlement\nGurantee\nFund","Index/Stock\nFutures",null,"Index/Stock\nOptions",null,"Total","Settlement\nGurantee\nFund"]
[null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement",null,null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement"]
["2019-20",1778.49,95.27,1165.5999999999999,10.91,3180.55,21.81,13384.326666667001,188.74,2131.8208333329999,532.07166666700004,16237.0425,2211.84]
["2020-21$",{"$f":"SUM(B8:B14)","v":2579.6400000000003},{"$f":"SUM(C8:C14)","v":66.83},13042.16,26.630000000000003,16029.119999999999,{"$f":"G14","v":23.27},{"$f":"SUM(H8:H14)","v":82252.13},{"$f":"SUM(I8:I14)","v":1266.32},15633.160000000002,2937.4600000000005,102089.06999999999,{"$f":"M14","v":2374.6}]
["Apr-20",135.52000000000001,5.79,173.72,1.8,316.83,21.93,15832.02,370.66,1809.08,431.1,18442.86,2231.7399999999998]
["May-20",123.84,4.07,197.23,0.84,366.55,22.07,12028.16,187.57,1889.56,261.08999999999997,14366.38,2244.09]
["Jun-20",179.15,2.75,299.07,2.62,598.74,22.3,12911.59,74.19,2510.98,494.02,15990.78,2268.39]
["Jul-20",399.43,13.89,2411.5500000000002,7.16,2911.07,22.56,12046.91,117.66,2450.4899999999998,478.65,15093.71,2283.2600000000002]
["Aug-20",538.19000000000005,9.34,2814.84,3.41,3444.88,22.84,8945.99,71.53,2028.28,367.69,11413.49,2309.02]
["Sep-20",730.73,25.69,3422.68,3.88,4182.9799999999996,23.05,11829.12,368.53,2499.11,373.22,15069.98,2341.41]
["Oct-20",472.78,5.3,3723.07,6.92,4208.07,23.27,8658.34,76.180000000000007,2445.66,531.69000000000005,11711.87,2374.6]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: ICCL and NSCCL"]

{"sheet":"37","index":37,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,10],[0,0,0,10],[1,0,2,0],[1,1,1,5],[1,6,1,10],[13,0,13,10]]}
["Table 37: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of BSE"]
["Year/Month","Percentage Share in Turnover",null,null,null,null,"Percentage Share in Open Interest"]
[null,"Pro","FPI","Mutual Funds","Banks","Others","Pro","FPI","Mutual Funds","Banks","Others"]
["2019-20",59.88,0.02,0,0,40.1,52.91,0,0,0,47.09]
["2020-21$",90.69,1.4285714E-2,0,0,9.2957142860000008,94.234773555000004,0,0,0,5.7652264449999997]
["Apr-20",99.98,0,0,0,0.02,49.89,0,0,0,50.11]
["May-20",99.92,0,0,0,0.08,74.459999999999994,0,0,0,25.54]
["Jun-20",68.209999999999994,0.1,0,0,31.69,50,0,0,0,50]
["Jul-20",93.09,0,0,0,6.91,84.4,0,0,0,15.6]
["Aug-20",92.33,0,0,0,7.67,72.78,0.01,0,0,27.21]
["Sep-20",86.75,0,0,0,13.25,97.548063526999996,0,0,0,2.4519364729999999]
["Oct-20",94.55,0,0,0,5.45,94.234773555000004,0,0,0,5.7652264449999997]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE."]

{"sheet":"38","index":38,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,10],[0,0,0,10],[1,0,2,0],[1,1,1,5],[1,6,1,10],[13,0,13,10]]}
["Table 38: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of NSE"]
["Year/Month","Percentage Share in Turnover",null,null,null,null,"Percentage Share in Open Interest"]
[null,"Pro","FPIs","Mutual Funds","Banks","Others","Pro","FPIs","Mutual Funds","Banks","Others"]
["2019-20",33.130000000000003,19.329999999999998,0.3,0,47.25,13.25,27.08,14.5,0,45.17]
["2020-21$",37.39,15.13,0.2,0,47.27,16.149999999999999,25.81,11.54,0,46.5]
["Apr-20",32.369999999999997,17.2,0.28999999999999998,0,50.14,11.99,33.979999999999997,15.95,0,38.08]
["May-20",34.69,17.84,0.28999999999999998,0,47.18,14.18,29.9,15.22,0,40.700000000000003]
["Jun-20",35.22,18.45,0.22,0,46.11,17.14,24.27,10.68,0,47.91]
["Jul-20",36.39,15.77,0.17,0,47.67,16.760000000000002,24.26,10.94,0,48.04]
["Aug-20",40.1,12.72,0.18,0,46.99,18.71,23.37,9.2200000000000006,0,48.7]
["Sep-20",41.45,12.18,0.15,0,46.22,17.78,20.68,8.31,0,53.23]
["Oct-20",41.52,11.74,0.12,0,46.61,16.46,24.24,10.47,0,48.83]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: NSE."]

{"sheet":"39","index":39,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[13,0,13,3],[14,0,14,3]]}
["Table 39: Instrument-wise Turnover in Index Derivatives at BSE"]
["(per cent)"]
["Year/Month","BSE 30 SENSEX","BSE SENSEX 50","BSE BANKEX"]
["2019-20",100,0,0]
["2020-21$",30.977142857,69.022857142999996,0]
["Apr-20",100,0,0]
["May-20",100,0,0]
["Jun-20",16.84,83.16,0]
["Jul-20",0,100,0]
["Aug-20",0,100,0]
["2020-09-01",0,100,0]
["Oct-20",0,100,0]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE."]

{"sheet":"40","index":40,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[13,0,13,3],[14,0,14,3]]}
["Table 40: Instrument-wise Turnover in Index Derivatives at NSE"]
[" (per cent)"]
["Year/Month","NIFTY","NIFTYIT","BANKNIFTY"]
["2019-20",39.006821029999998,9.5086300000000003E-4,60.992228109999999]
["2020-21$",48.775354919999998,6.9999999999999994E-5,51.224583189999997]
["Apr-20",49.588625409999999,3.1785899999999998E-4,50.411056729999999]
["May-20",46.989811170000003,2.1736600000000001E-4,53.009971460000003]
["Jun-20",54.365526439999996,1.2704099999999999E-4,45.634346520000001]
["Jul-20",49.938886799999999,0,50.061113200000001]
["Aug-20",49.84197013,0,50.15802987]
["Sep-20",47.363995090000003,0,52.636004909999997]
["Oct-20",45.152463480000002,0,54.847536519999998]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: NSE."]

{"sheet":"41","index":41,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,11],[15,0,15,11],[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,1,7],[1,8,2,9],[1,10,2,11],[2,4,2,5],[2,6,2,7]]}
["Table 41: Trends in Currency Derivatives Segment at BSE"]
["Year/ Month","No. of Trading Days","Currency Futures",null,"Currency  Options",null,null,null,"Total",null,"Open Interest at the end of  the Month"]
[null,null,null,null,"Call",null,"Put"]
[null,null,"No. of Contracts","Turnover (₹ crore)","No. of Contracts","Turnover (₹ crore)","No. of Contracts ","Turnover (₹ crore)","No. of Contracts","Turnover (₹ crore)","No. of Contracts ","Value \n(₹ crore)"]
["2019-20",243,400927037,2852910.86,214693422,1538428.304,328897100,2291934.5920000002,944517559,6683273.7560000001,2288248,17251.47]
["2020-21$",{"$f":"SUM(B7:B13)","v":143},{"$f":"SUM(C7:C13)","v":154051628},1155188.3493000001,85924590,655998.65210000006,130580835,960672.20829999994,370557053,2771859.2197000002,{"$f":"K13","v":789087},{"$f":"L13","v":5854.0947080400001}]
["Apr-20",17,18156395,138820.29,6476787,50460.69,10892155,81863.399999999994,35525337,271144.38,1273915,9570.3700000000008]
["May-20",18,17436081,132222.54999999999,9017175,69915.06,14011006,104007.3,40464262,306144.90000000002,678398,5151.87]
["Jun-20",22,23756034,180393.67,15910793,123085.45,21994582,163766.07,61661409,467245.2,712652,5394.75]
["Jul-20",23,25338836,190382.76,10697892,81976.56,22387440,164807.01,58424168,437166.34,639219,4839.72]
["Aug-20",21,22489598,168111.03,17886515,136249.15,20029214,147430.07999999999,60405327,451790.26,806498,5966.81]
["Sep-20",22,25789498,189948.5215,14614903,109555.8563,17967576,129973.0131,58371977,429477.3909,1051011,7777.820635]
["Oct-20",20,21085186,155309.52780000001,11320525,84755.885800000004,23298862,168825.3352,55704573,408890.7488,789087,5854.0947080400001]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE"]

{"sheet":"42","index":42,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,1,3],[1,4,1,7],[1,8,1,9],[1,10,1,11],[2,2,3,2],[2,3,3,3],[2,4,2,5],[14,0,14,11],[15,0,15,11],[2,6,2,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[13,0,13,11]]}
["Table 42: Trends in Currency Derivatives Segment at NSE"]
["Year/     Month","No. of Trading  Days","Currency Futures",null,"Currency Options",null,null,null,"Total",null,"Open Interest at the\nend of Month"]
[null,null,"No. of\nContracts","Turnover\n(₹ crore)","Call",null,"Put",null,"No. of Contracts ","Turnover (₹ crore)","No. of\nContracts","Value\n(₹ crore)"]
[null,null,null,null,"No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)"]
["2019-20",243,660128849,4806639.4400000004,352374185,2520679.83,327759150,2327074.4989999998,1340262184,9654393.7679999992,6826565,51810.079769999997]
["2020-21$",{"$f":"SUM(B7:B13)","v":143},{"$f":"SUM(C7:C13)","v":396413449},3079860.0650999998,231902279,1744919.702,210042012,1568201.8689000001,838357740,6392981.6360999998,{"$f":"K13","v":4976914},{"$f":"L13","v":37495.171690000003}]
["Apr-20",17,48012637,372205.46909999999,22067309,169628.2971,20327816,154448.6911,90407762,696282.45719999995,4263641,32203.754280000001]
["May-20",18,47443900,367808.5477,26027374,198497.3371,21602048,163221.3511,95073322,729527.23580000002,3650637,27865.660650000002]
["Jun-20",22,58286091,456224.96409999998,34559311,263411.82620000001,30334567,229533.27929999999,123179969,949170.06960000005,4593310,35033.710249999996]
["Jul-20",23,55160793,429355.04470000003,35967687,271284.10320000001,32389301,242756.524,123517781,943395.67189999996,4149989,31789.242910000001]
["Aug-20",21,57090417,447196.38219999999,36908748,276899.21950000001,33912469,252768.72779999999,127911634,976864.32949999999,5261518,39274.370020000002]
["Sep-20",22,70415755,543128.39760000003,40102425,296868.95429999998,38109897,280076.2378,148628077,1120073.5900000001,5393259,40182.189149999998]
["Oct-20",20,60003856,463941.2597,36269425,268329.96460000001,33365914,245397.05780000001,129639195,977668.28209999995,4976914,37495.171690000003]
["Notes: 1. Trading Value :- For Futures, Value of contract = Traded Qty*Traded Price. 2. For Options, Value of contract = Traded Qty*(Strike Price+Traded Premium)"]
["$ indicates as on October 31, 2020"]
["Source: NSE."]

{"sheet":"43","index":43,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,11,3,11],[14,0,14,9],[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,1,3],[1,4,1,7],[1,8,1,9],[1,10,1,11],[2,2,3,2],[2,3,3,3],[2,4,2,5],[15,0,15,9],[2,6,2,7],[2,8,3,8],[2,9,3,9],[2,10,3,10]]}
["Table 43: Trends in Currency Derivatives Segment at MSEI"]
["Year/     Month","No. of Trading  Days","Currency Futures",null,"Currency Options",null,null,null,"Total",null,"Open Interest at the\nend of Month"]
[null,null,"No. of\nContracts","Turnover\n(₹ crore)","Call",null,"Put",null,"No. of Contracts ","Turnover (₹ crore)","No. of\nContracts","Value\n(₹ crore)"]
[null,null,null,null,"No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)"]
["2019-20",243,5783785,41521.070337750003,234838,1757.805652,273575,2045.6429625000001,6292198,45324.51895225,6073,45.977366000000004]
["2020-21$",{"$f":"SUM(B7:B13)","v":143},{"$f":"SUM(C7:C13)","v":4246042},31628.104055,1595,12.31153125,2929,21.178994749999998,4250566,31661.594581000001,{"$f":"K13","v":12722},{"$f":"L13","v":95.381641999999999}]
["Apr-20",17,233754,1785.2814207500001,0,0,0,0,233754,1785.2814207500001,22075,166.24752325]
["May-20",18,224568,1702.42343375,0,0,0,0,224568,1702.42343375,9679,73.879713749999993]
["Jun-20",22,375979,2854.2512265,0,0,0,0,375979,2854.2512265,15683,119.16822025]
["Jul-20",23,537915,4042.2201822500001,565,4.2009162499999997,2500,18.001124999999998,540980,4064.4222235000002,13180,99.837251749999993]
["Aug-20",21,706873,5291.3987129999996,0,0,0,0,706873,5291.3987129999996,14445,106.699082]
["Sep-20",22,934628,6884.9063724999996,500,3.7099250000000001,0,0,935128,6888.6162974999997,18028,134.462391]
["Oct-20",20,1232325,9067.6227062500002,530,4.40069,429,3.1778697500000002,1233284,9075.201266,12722,95.381641999999999]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: MSEI"]

{"sheet":"44","index":44,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,14],[2,0,4,0],[2,1,2,4],[2,5,4,5],[2,6,2,9],[2,10,4,10],[2,11,2,14],[15,0,15,14],[16,0,16,14],[2,15,4,15],[3,1,3,2],[3,3,3,4],[3,6,3,7],[3,8,3,9],[3,11,3,12],[3,13,3,14]]}
["Table 44: Settlement Statistics of Currency Derivatives Segment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," (₹ crore)"]
["Year/     Month","BSE",null,null,null,"Total","NSE",null,null,null,"Total","MSEI",null,null,null,"Total"]
[null,"Currency\nFutures",null,"Currency Options",null,null,"Currency\nFutures",null,"Currency Options",null,null,"Currency\nFutures",null,"Currency Options"]
[null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement",null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement",null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement"]
["2019-20",7222.5,246.08,5002.79,76.14,12547.51,9038.7684582069996,266.00635390000002,1351.72486134,553.36033283999996,11209.860006286999,28.27095825,1.03627519,4.3813499999999998E-2,1.1548999999999999E-3,29.352201839999999]
["2020-21$",{"$f":"SUM(B8:B14)","v":3528.66},{"$f":"SUM(C8:C14)","v":62.81},2741.34,57.589999999999996,6390.4,4351.2792988379997,75.241955399999995,699.58276437000006,222.45664453999998,5348.5606631479995,0,0,0,0,0]
["Apr-20",1122.19,12.14,322.02999999999997,8.34,1464.7,1732.109531028,17.211897870000001,118.462208,30.032362689999999,1897.8159995880001,0,0,0,0,0]
["May-20",457.51,4,312.08999999999997,3.94,777.54,555.48637647999999,4.4865100900000003,79.326992250000004,16.697893109999999,655.99777193,0,0,0,0,0]
["Jun-20",288.39999999999998,4.17,334.02,4.12,630.71,360.42006702999998,6.8948276499999999,89.082384500000003,23.39430685,479.79158603000002,0,0,0,0,0]
["Jul-20",371.52,5.94,417.16,12.75,807.37,459.97380621999997,9.0436626400000009,95.182137499999996,52.270053939999997,616.46966029999999,0,0,0,0,0]
["Aug-20",475.56,6.14,387.25,6.53,875.48,461.19636310999999,6.2852173699999998,97.782923620000005,27.036283709999999,592.30078780999997,0,0,0,0,0]
["Sep-20",394.99,6.53,520.28,9.3699999999999992,931.17,359.49221784000002,8.2159539600000002,119.67712975000001,34.743132070000001,522.12843362000001,0,0,0,0,0]
["Oct-20",418.49,23.89,448.51,12.54,903.43,422.60093712999998,23.103885819999999,100.06898875,38.28261217,584.05642387,0,0,0,0,0]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: ICCL, NSCCL and MCCIL."]

{"sheet":"45","index":45,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,8],[0,0,0,8],[1,0,2,0],[1,1,1,7],[1,8,1,14],[13,0,13,8]]}
["Table 45: Instrument-wise Turnover in Currency Derivatives Segment of BSE"]
["Year/Month","Turnover (₹ crore)",null,null,null,null,null,null,"Open Interest as on last day of the month (in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","EURUSD","GBPUSD","USDJPY","USDINR","EURINR","GBPINR","JPYINR","EURUSD","GBPUSD","USDJPY"]
["2019-20",5129221.2883187998,1792.549354,2170.6853637499999,1823.75314875,9.3858820999999995E-2,3.7072341000000002E-2,0.16362080000000001,2270484,7992,338,9434,0,0,0]
["2020-21$",{"$f":"SUM(B6:B12)","v":1150713.7786760002},{"$f":"SUM(C6:C12)","v":2626.91088025},2402.1706995000004,466.19494699999996,0,0,0,{"$f":"I12","v":774835},{"$f":"J12","v":1847},7234,5171,0,0,0]
["Apr-20",138649.70000000001,96.07,126.95,75.66,0,0,0,1271120,1045,646,1104,0,0,0]
["May-20",131726.06,318.10000000000002,229.2,89.68,0,0,0,652421,20386,2921,2670,0,0,0]
["Jun-20",179519.04,434.82,512.07000000000005,96.81,0,0,0,700596,9437,2256,363,0,0,0]
["Jul-20",189568.32,642.51,266.22000000000003,33.79,0,0,0,598516,34047,5358,1298,0,0,0]
["Aug-20",167199.76999999999,614.19000000000005,384.93,45.08,0,0,0,785958,16288,3611,641,0,0,0]
["Sep-20",189441.48628300001,157.95455525,480.03266150000002,52.070701999999997,0,0,0,1034804,14144,1744,319,0,0,0]
["Oct-20",154609.402393,363.26632499999999,402.76803799999999,73.104245000000006,0,0,0,774835,1847,7234,5171,0,0,0]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE"]

{"sheet":"46","index":46,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,15,8],[16,0,16,8],[0,0,0,6],[1,0,2,0],[1,1,1,7],[1,8,1,14],[13,0,13,8],[14,0,14,8]]}
["Table 46: Instrument-wise Turnover in Currency Derivatives Segment of NSE"]
["Year/Month","Turnover (₹ crore)",null,null,null,null,null,null,"Open Interest as on last day of the month ( in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","EURUSD","GBPUSD","USDJPY","USDINR","EURINR","GBPINR","JPYINR","EURUSD","GBPUSD","USDJPY"]
["2019-20",9200220.8990000002,168295.07449999999,365744.80619999999,76795.437569999995,11624.22788,12483.349190000001,225.53186160000001,6680611,81513,32141,30965,650,643,24]
["2020-21$",{"$f":"SUM(B6:B12)","v":5714731.5950999996},{"$f":"SUM(C6:C12)","v":235400.35649000001},373336.44842999999,61704.453503000004,3401.6368339999999,4364.0215685000003,43.123876680000002,{"$f":"I12","v":5607942},{"$f":"J12","v":192303},111715,62198,2767,1770,114]
["Apr-20",655054.75670000003,11949.74469,23656.508689999999,5267.9496369999997,129.5959632,221.4217347,2.4798537180000002,4875455,67920,42712,36164,1128,1805,47]
["May-20",663982.92599999998,20144.290290000001,37101.386590000002,7695.0969370000003,230.85869769999999,367.38587510000002,5.291468558,4204478,165613,42731,32939,3028,2283,18]
["Jun-20",853857.83900000004,28614.879359999999,55969.384319999997,9383.4079270000002,546.59406430000001,790.48008149999998,7.4848078119999997,4288347,154408,72300,31324,2564,2375,25]
["Jul-20",844302.73690000002,41198.973579999998,47785.242599999998,8475.8479449999995,849.56517020000001,779.05277439999998,4.2529588690000004,4778747,273940,124436,32991,6381,1897,77]
["Aug-20",857995.12269999995,50143.458039999998,56740.37298,10440.619259999999,745.82706559999997,789.41297750000001,9.5164741240000001,4831227,210451,99422,32832,7162,3024,12]
["Sep-20",981988.99509999994,45279.987699999998,79550.149439999994,11919.148370000001,562.6200652,761.34424320000005,11.34469526,5125997,155352,59034,28800,3348,1655,23]
["Oct-20",857549.21869999997,38069.022830000002,72533.403810000003,8522.3834270000007,336.57580780000001,654.92388210000001,2.753618339,5607942,192303,111715,62198,2767,1770,114]
["Notes -"]
["1. Cross Currency was introduced wef Feb 27, 2018"]
["2. Options contracts on EURINR,GBPINR,JPYINR were introduced wef Feb 27, 2018"]
["$ indicates as on October 31, 2020"]
["Source: NSE."]

{"sheet":"47","index":47,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,15,8],[16,0,16,8],[0,0,0,6],[1,0,2,0],[1,1,1,4],[1,5,1,8],[13,0,13,8],[14,0,14,8]]}
["Table 47:  Instrument-wise Turnover in Currency Derivatives Segment of MSEI"]
["Year/Month","Turnover (₹ crore)",null,null,null,"Open Interest as on last day of the month\n(in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","USDINR","EURINR","GBPINR","JPYINR"]
["2019-20",43153.868839249997,941.32911249999995,1223.80989875,5.5111017499999999,6062,11,0,0]
["2020-21$",{"$f":"SUM(B6:B12)","v":31533.391305750003},{"$f":"SUM(C6:C12)","v":89.755655749999988},38.230051750000001,0.21756775,{"$f":"F12","v":12488},{"$f":"G12","v":9},225,0]
["Apr-20",1782.7734902499999,1.07487325,1.4330572500000001,0,21998,52,25,0]
["May-20",1694.2693977500001,5.6188107499999997,2.5352252499999999,0,9148,506,25,0]
["Jun-20",2830.3128132500001,18.986320249999999,4.9520929999999996,0,15405,201,77,0]
["Jul-20",4050.15318325,11.57521225,2.6938279999999999,0,12489,691,0,0]
["Aug-20",5267.13913925,21.453854249999999,2.7702545000000001,3.5465000000000003E-2,14061,332,52,0]
["Sep-20",6855.9462997500004,19.511039499999999,13.0047035,0.15425475,17122,818,80,8]
["Oct-20",9052.7969822499999,11.5355455,10.840890249999999,2.7848000000000001E-2,12488,9,225,0]
["Notes -"]
["Data includes Notional Value for Options"]
["Excludes data of Interest Rate Futures"]
["$ indicates as on October 31, 2020"]
["Source: MSEI"]

{"sheet":"48","index":48,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,8],[0,0,0,9],[2,0,3,0],[2,1,2,4],[2,5,2,8],[14,0,14,8]]}
["Table 48: Maturity-wise Turnover in Currency Derivatives Segment of BSE "]
[null,null,null,null,null,null,null,null,"(₹ crore)"]
["Year/Month","Currency Futures",null,null,null,"Currency Options"]
[null,"1 Month","2 Month","3 Month","> 3 Months","1 Month","2 Month","3 Month","> 3 Months"]
["2019-20",2414981.7793000001,345729.96879999997,10549.547200000001,531.93679999999995,3124335.8001999999,235545.02340000001,127.5506,0]
["2020-21$",{"$f":"SUM(B7:B13)","v":840091.74620000017},{"$f":"SUM(C7:C13)","v":214744.11859999999},4659.9271000000008,253.74529999999999,975883.3713,232520.16930000001,22.7577,0]
["Apr-20",94355.03,43315.96,1144.9000000000001,4.4000000000000004,97103.31,35217.67,3.11,0]
["May-20",98146.42,24875.23,274.55,8.24,89806.55,33912.230000000003,7.81,0]
["Jun-20",129794.97,36969.9,331.2,1.74,199656.84,37358.5,6.09,0]
["Jul-20",136887.07,33567.660000000003,815.07,6.06,171323.64,33216.53,5.74,0]
["Aug-20",124186.34,29186.13,706.36,31.53,183546.54,23556.01,0,0]
["Sep-20",152283.57310000001,20091.901300000001,284.26319999999998,5.3711000000000002,103470.18429999999,39944.986799999999,0,0]
["Oct-20",104438.3431,26737.337299999999,1103.5839000000001,196.4042,130976.307,29314.2425,7.7000000000000002E-3,0]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: BSE"]

{"sheet":"49","index":49,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,8],[0,0,0,8],[2,0,3,0],[2,1,2,4],[2,5,2,8],[14,0,14,8]]}
["Table 49: Maturity-wise Turnover in Currency Derivatives Segment of NSE  "]
[null,null,null,null,null,null,null,null,"(₹ crore)"]
["Year/Month","Currency Futures",null,null,null,"Currency Options"]
[null,"1 Month","2 Month   ","3 Month","> 3 Months","1 Month","2 Month","3 Month","> 3 Months"]
["2019-20",3697571.6570000001,991649.22309999994,77821.751610000007,39596.808019999997,2565212.378,942140.94609999994,440868.72080000001,899532.28419999999]
["2020-21$",{"$f":"SUM(B7:B13)","v":2473846.6951000001},{"$f":"SUM(C7:C13)","v":541332.00555},45676.304210000002,19005.060157,1810771.51,664320.26574000006,254262.71723000001,583767.07764000003]
["Apr-20",282105.40490000002,81657.161569999997,6045.598669,2397.3038889999998,153692.5281,74087.095490000007,31407.265029999999,64890.099569999998]
["May-20",289073.96289999998,71291.097030000004,6200.1757619999998,1243.3119360000001,193516.68460000001,76267.898230000006,36481.874389999997,55452.230940000001]
["Jun-20",368055.19400000002,79812.844859999997,5741.6815909999996,2615.243633,313585.3321,79414.351620000001,32072.21573,67873.206059999997]
["Jul-20",343621.22739999997,75715.724600000001,6821.7067209999996,3196.3859750000001,280693.14199999999,101842.9618,32794.20306,98710.320210000005]
["Aug-20",353349.68550000002,82858.698250000001,7197.469908,3790.5285650000001,294176.71529999998,101638.20329999999,34641.540789999999,99211.487869999997]
["Sep-20",452948.27860000002,80381.21888,6470.9441820000002,3327.9559960000001,313046.12719999999,105356.2873,45642.476219999997,112900.30130000001]
["Oct-20",384692.94179999997,69615.26036,7198.7273770000002,2434.3301630000001,262060.98069999999,125713.46799999999,41223.142010000003,84729.431689999998]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: NSE."]

{"sheet":"50","index":50,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,8],[0,0,0,8],[2,0,3,0],[2,1,2,4],[2,5,2,8],[14,0,14,8]]}
["Table 50: Maturity-wise Turnover in Currency Derivatives Segment of MSEI "]
[null,null,null,null,null,null,null,null,"(₹ crore)"]
["Year/Month","Currency Futures",null,null,null,"Currency Options"]
[null,"1 Month","2 Month   ","3 Month","> 3 Months","1 Month","2 Month","3 Month","> 3 Months"]
["2019-20",39121.486169999996,2373.3683209999999,25.859646250000001,0.35620000000000002,371.327628,65.06337225,0,0]
["2020-21$",{"$f":"SUM(B7:B13)","v":29659.568727500002},{"$f":"SUM(C7:C13)","v":1959.8106758500001},8.4674622499999987,0,25.907766250000002,0.74434999999999996,0,0]
["Apr-20",1556.7071227500001,227.80689924999999,0.76739875000000002,0,0,0,0,0]
["May-20",1483.9977269999999,211.95682479999999,6.4688822500000001,0,0,0,0,0]
["Jun-20",2632.5162937499999,220.59277650000001,1.14215625,0,0,0,0,0]
["Jul-20",3514.566503,527.65367979999996,0,0,22.202041250000001,0,0,0]
["Aug-20",5026.9830840000004,264.28710949999999,0,0,0,0,0,0]
["Sep-20",6583.3953949999996,301.36740800000001,1.489E-2,0,2.9655749999999999,0.74434999999999996,0,0]
["Oct-20",8861.4026020000001,206.14597800000001,7.4135000000000006E-2,0,0.74014999999999997,0,0,0]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: MSEI"]

{"sheet":"51","index":51,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,19,15],[0,0,0,14],[1,0,3,0],[1,1,3,1],[1,2,1,5],[1,12,1,15],[2,2,2,3],[2,4,2,5],[2,8,2,9],[2,10,2,11],[2,6,2,7],[18,0,18,15],[1,6,1,11],[15,0,15,15],[16,0,16,15],[17,0,17,15],[2,12,2,13],[2,14,2,15],[14,0,14,15]]}
["Table 51: Trading Statistics in Interest Rate Futures Segment "]
["Year/ Month","No. of Trading Days","BSE",null,null,null,"NSE",null,null,null,null,null,"MSEI"]
[null,null,"Interest Rate Futures",null,"Open Interest at\nthe end of",null,"Interest Rate Futures",null,"Interest Rate Option",null,"Open Interest at\nthe end of**",null,"Interest RateFutures",null,"Open Interest at the end of "]
[null,null,"No. of Contracts","Traded Value \n(₹ crore)","No. of Contracts","Value \n(₹ crore)","No. of\nContracts","Traded Value \n(₹ crore)","No. of\nContracts","Traded Value \n(₹ crore)","No. of\nContracts","Value \n(₹ crore)","No. of Contracts ","Traded Value \n(₹ crore)","No. of Contracts","Value \n(₹ crore)"]
["2019-20",243,4917740,100045.43150000001,32362,682.81,17217124,351817.75828999997,444761,8993.3808099999987,77036,1592.8485949999999,0,0,0,0]
["2020-21$",{"$f":"SUM(B7:B13)","v":143},{"$f":"SUM(C7:C13)","v":801165},16591.146500000003,{"$f":"E13","v":1252},{"$f":"F13","v":27.858011319999999},{"$f":"SUM(G7:G13)","v":3516193},{"$f":"SUM(H7:H13)","v":72118.637583000003},41368,854.3618295,{"$f":"K13","v":58345},{"$f":"L13","v":1205.0731149999999},{"$f":"SUM(M7:M13)","v":0},0,{"$f":"O13","v":0},0]
["Apr-20",17,117135,2394.6293999999998,22389,486.62,462985,9422.5825435000006,15183,311.16420499999998,51482,1075.917142,0,0,0,0]
["May-20",18,92350,1898.7684999999999,32071,695.75,578495,11886.515042499999,15039,311.33295500000003,66972,1409.258315,0,0,0,0]
["Jun-20",22,207052,4307.7403000000004,25260,525.02,803319,16565.8619755,10776,224.1784285,102803,2140.6479290000002,0,0,0,0]
["Jul-20",23,193802,4082.3089,19100,399.24,554091,11472.240318,266,5.5394410000000001,59617,1260.5093810000001,0,0,0,0]
["Aug-20",21,65635,1339.4258,5447,112.12,434184,8835.9610809999995,3,6.1254500000000003E-2,65722,1365.007214,0,0,0,0]
["Sep-20",22,30352,618.83699999999999,1750,37.548735000000001,389067,7966.1150095000003,101,2.0855454999999998,45801,953.33148700000004,0,0,0,0]
["Oct-20",20,94839,1949.4366,1252,27.858011319999999,294052,5969.361613,0,0,58345,1205.0731149999999,0,0,0,0]
["Notes -"]
["$ indicates as on October 31, 2020"]
["IR Options were launched at NSE during Dec 2019, the data has been revised accordingly"]
["*IRF includes 6 Year, 10 Year, 13 Year GSecs and 91 DTB"]
["**Open interest is valued at daily settlement prices"]
["**The Open interest pertains to NSE Clearing and Includes the data of multiple exchnages)"]
["Source: BSE, NSE and MSEI"]

{"sheet":"52","index":52,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,6],[0,0,0,7],[2,0,3,0],[2,1,2,2],[2,3,2,4],[2,5,2,6],[14,0,14,6]]}
["Table 52: Settlement Statistics in Interest Rate Futures Segment "]
[null,null,null,null,null,null,"(₹ crore)"]
["Year/ Month","BSE",null,"NSE",null,"MSEI"]
[null,"MTM\nSettlement","Physical Delivery Settlement","MTM\nSettlement","Physical Delivery Settlement","MTM Settlement","Physical Delivery Settlement"]
["2019-20",1417.0222240000001,23.052129999999998,1400.2491,20.05797746,0,0]
["2020-21$",{"$f":"SUM(B7:B13)","v":283.06012900000002},{"$f":"SUM(C7:C13)","v":2.5318460000000003},314.26595401999998,2.4653249599999998,0,0]
["Apr-20",100.356579,0.31318800000000002,78.215149999999994,0.38330288000000001,0,0]
["May-20",50.891993999999997,4.7840000000000001E-2,51.993362500000003,0.26414280000000001,0,0]
["Jun-20",40.929543000000002,0.73642099999999999,48.623053499999997,0.33827309999999999,0,0]
["Jul-20",25.355761000000001,3.3484E-2,42.119494000000003,0.17433314,0,0]
["Aug-20",25.204654999999999,1.0989629999999999,38.964887019999999,0.59955239999999999,0,0]
["Sep-20",23.771080000000001,8.4750000000000006E-2,31.664533500000001,9.5656599999999994E-2,0,0]
["Oct-20",16.550516999999999,0.2172,22.685473500000001,0.61006404000000003,0,0]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: ICCL, NSCCL and MCCIL"]

{"sheet":"53","index":53,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,3],[12,0,12,5],[13,0,13,5]]}
["Table 53: Trends in Foreign Portfolio Investment"]
["Year/Month","Gross Purchase (₹ crore)","Gross Sales (₹ crore)","Net Investment (₹ crore)","Net Investment (USD million)","Cumulative Net Investment (USD million)"]
["2019-20",1905516.99,1933046.1599999997,-27529.170000000013,-3041.5499999999993,245112.63]
["2020-21$",{"$f":"SUM(B5:B11)","v":1152523.31},{"$f":"SUM(C5:C11)","v":1074918.1299999999},77605.180000000008,10437.84,{"$f":"F11","v":255550.47}]
["Apr-20",144753.65,159612.19,-14858.54,-1961.18,243151.45]
["May-20",150169.19,157525.04,-7355.85,-972.51,242178.94]
["Jun-20",202141.05,176131.62,26009.43,3440.94,245619.88]
["Jul-20",151569.69,148268.25,3301.44,450.99,246070.87]
["Aug-20",177960.26,128081.31,49878.95,6661.85,252732.72]
["Sep-20",168469.44,169665.82,-1196.3800000000001,-156.61000000000001,252576.11]
["Oct-20",157460.03,135633.9,21826.13,2974.36,255550.47]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: NSDL, CDSL"]

{"sheet":"54","index":54,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,16,5]]}
["Table 54: Notional Value of Offshore Derivative Instruments (ODIs) compared to Assets Under Custody (AUC) of FPIs/Deemed FPIs"]
["Year/ Month","Notional value of ODIs on Equity, Debt & Derivatives  (₹ crore) ","Notional value of ODIs on Equity & Debt  excluding Derivatives  (₹ crore) ","Assets Under Custody of FPIs/Deemed FPIs  (₹ crore)","Notional value of ODIs on Equity, Debt & Derivatives as % of  Assets Under Custody of FPIs/Deemed FPIs","Notional value of ODIs on Equity & Debt  excluding Derivatives as % of  Assets Under Custody of FPIs/Deemed FPIs"]
["2019-20",48006.398270333913,47852,2490223,{"$f":"(B3/D3)*100","v":1.9277951520941663},{"$f":"(C3/D3)*100","v":1.9215949736228441}]
["2012-21$",{"$f":"B11","v":78686.403269105824},{"$f":"C11","v":78686.403269105824},{"$f":"D11","v":3436258},{"$f":"(B4/D4)*100","v":2.2898863609515296},2.2898863609515296]
["Apr-20",57100,56923,2819841,2.0249368670077499,2.0186599173499498]
["May-20",60027,59869,2743734,2.1877849674932044,2.1820263917712137]
["Jun-20",62137.931794577897,61974.282086353691,2979826,2.0852872548456824,2.0797953332293124]
["Jul-20",63228,63035,3167785,1.9959687920739571,1.9898762068764138]
["Aug-20",74027.297051521688,73826,3317805,2.2312130173871485,2.2251458419045123]
["Sep-20",69820.572747645827,69820.572747645827,3322393,2.1015145633778372,2.1015145633778372]
["2020-10-01",78686.403269105824,78686.403269105824,3436258,2.2898863609515296,2.2898863609515296]
["Notes:"]
["1. Figures are compiled based on reports submitted by FPIs/deemed FPIs issuing ODIs."]
["2. Column 4 Figures are compiled on the basis of reports submitted by custodians & does not includes positions taken by FPIs/deemed FPIs in derivatives."]
["3. The total value of ODIs excludes the unhedged positions & portfolio hedging positions taken by the FPIs/deemed FPIs issuing ODIs."]
["4. Column C is being provided which depicts the Total Value of ODI issued -with underlying as  Equity ,Debt & Hybrid Securities but excluding derivatives"]
["$ indicates as on October 31, 2020"]
["Source: SEBI."]

{"sheet":"55","index":55,"n_rows":16,"n_cols":29,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,27,1,28],[0,0,0,25],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[1,15,1,16],[12,0,12,25],[13,0,13,25],[14,0,14,25],[15,0,15,25],[1,17,1,18],[1,19,1,20],[1,21,1,22],[1,23,1,24],[1,25,1,26]]}
["Table 55: Assets under the Custody of Custodians"]
["Type of Client","FPIs ",null,"Foreign\nDepositories",null,"FDI\nInvestments",null,"Foreign\nVenture\nCapital\nInvestments",null,"OCBs",null,"NRIs",null,"Mutual\nFunds",null,"Corporates",null,"Banks",null,"Insurance\nCompanies",null,"Local\nPension\nFunds",null,"Financial\nInstitutions",null,"Others",null,"Total"]
[null,"No.","Amount (₹ crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)","No.","Amount (`crore)"]
["2019-20",9825,2490223.13,66,227791.97,2079,832863.69,208,38124.839999999997,25,1582.04,693,2098.92,1624,1891137.87,598,88517.75,121,412044.02,788,1547943.43,124,477968.29,25,40702.49,25595,967716.71,41771,9018715.1500000004]
["2020-21$",{"$f":"B12","v":9984},{"$f":"C12","v":3436257.51},66,382987.29,2229,{"$f":"G12","v":1082379.3799999999},211,40576.449999999997,25,1828.28,785,2732.66,1632,2166199.39,640,103530,123,527990.69999999995,793,1854228.43,115,544212.66,26,36541.14,28257,1091199.3,44886,11270663.189999999]
["Apr-20",9916,2819840.63,66,264852.96000000002,2088,891652.54,208,38313.550000000003,25,1678.47,693,2287.0300000000002,1621,2031625.42,600,92221.83,121,484474.78,790,1656179.49,124,486918.55,26,42889.59,25629,1000395.04,41907,9813329.8800000008]
["May-20",9912,2743734.07,66,251650.89,2098,869794.25,210,38512.69,25,1564.8,698,2438.62,1622,2001267.16,600,96705.97,121,496496.67,790,1650619.6,112,493260.74,26,44232.99,25655,986317.56,41935,9676596.0099999998]
["Jun-20",9911,2979825.58,66,310240.28999999998,2106,927607.89,211,38925.86,25,1721.14,703,2639.04,1625,2032087.29,598,98195.29,124,494660.29,793,1731728.51,112,503181.73,26,44802.16,25829,1016537.42,42129,10182152.49]
["Jul-20",10059,3167785.41,66,342150.79,2145,981263.97,212,39105.11,25,1769.78,740,2753.77,1630,2101536.2799999998,615,99802.42,124,509473.4,793,1790710.93,119,513076.47999999998,26,45490,26655,1040909.16,43209,10635827.5]
["Aug-20",10071,3317805.32,66,361713.46,2155,1016525.73,212,39604.959999999999,25,1760.36,746,2879.08,1636,2158248.83,624,101890.3,123,520463.14,792,1834368.24,119,524306.98,26,46103.4,27256,1065804.43,43851,10991474.23]
["Sep-20",9972,3322393,66,368260.05,2177,1050353.81,212,40359.68,25,1604.49,765,2742.21,1630,2098922.56,635,102139.5,124,513385.09,794,1823503.44,115,533973.80000000005,26,42735.5,27814,1062131.21,44355,10962504.34]
["OCT-20",9984,3436257.51,66,382987.29,2229,1082379.3799999999,211,40576.449999999997,25,1828.28,785,2732.66,1632,2166199.39,640,103530,123,527990.69999999995,793,1854228.43,115,544212.66,26,36541.14,28257,1091199.3,44886,11270663.189999999]
["Notes: 1. With the commencement of FPI Regime from June 1, 2014, the erstwhile FIIs, Sub Accounts and QFIs are merged into a new investor class termed as .Foreign Portfolio Investors (FPIs)."]
["2. \"Others\" include Portfolio manager, partnership firm, trusts, depository receipts, AIFs, FCCB, HUFs, Brokers etc."]
["$ indicates as on October 31, 2020"]
["Source: Custodians."]

{"sheet":"56","index":56,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,7,2,9],[2,10,3,10],[14,0,14,4],[15,0,15,4],[0,0,0,4],[2,0,3,0],[2,1,2,3],[2,4,2,6]]}
["Table 56: Trends in Resource Mobilization by Mutual Funds "]
[null,null,null,null,null,null,null,null,null,null," (₹ crore)"]
["Year / Month","Gross Mobilisation",null,null,"Redemption",null,null,"Net Inflow/ Outflow",null,null,"Assets at the\nEnd of\nPeriod"]
[null,"Pvt. Sector","Public Sector","Total","Pvt. Sector","Public Sector","Total","Pvt. Sector","Public Sector","Total"]
["2019-20",14989990.49,3823467.281,18813457.77,14965931.060000001,3760225.8909999998,18726156.949999999,24059.435409999998,63241.390570000003,87300.825979999994,2226202.8650000002]
["2020-21$",{"$f":"SUM(B7:B13)","v":3835246.523},{"$f":"SUM(C7:C13)","v":1389205.6848000002},5224452.2079999996,3660763.0490000001,1317865.9689,4978629.0180000002,174483.47359999997,71339.715919999988,245823.18950000001,{"$f":"K13","v":2822940.8739999998}]
["Apr-20",614258.18709999998,206442.2309,820700.4179,593456.62309999997,181244.3076,774700.93070000003,20801.56393,25197.923299999999,45999.487229999999,2393485.5430000001]
["May-20",619156.47290000005,246977.14910000001,866133.62210000004,562437.9669,232882.14240000001,795320.10930000001,56718.506070000003,14095.0067,70813.512770000001,2454757.5299999998]
["Jun-20",711244.24100000004,249561.2634,960805.505,701503.31,252036.22399999999,953539.53399999999,9740.9320599999992,-2474.96056,7265.9714999999997,2548848.4339999999]
["Jul-20",518550.88099999999,192070.14939999999,710621.02899999998,462909.77,157898.97150000001,620808.74100000004,55641.10914,34171.177799999998,89812.286999999997,2711894.15]
["Aug-20",404939.098,151656.2072,556595.30599999998,414119.41,157028.75450000001,571148.16500000004,-9180.3112000000001,-5372.5372399999997,-14552.8485,2749388.53]
["Sep-20",496584.97100000002,169773.86259999999,666358.83299999998,534398.20700000005,184051.8357,718450.04299999995,-37813.235030000003,-14277.983109999999,-52091.218099999998,2685981.915]
["Oct-20",470512.67200000002,172724.8222,643237.495,391937.76199999999,152723.73319999999,544661.495,78574.908630000005,20001.089029999999,98575.997600000002,2822940.8739999998]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: SEBI."]

{"sheet":"57","index":57,"n_rows":91,"n_cols":14,"rows_kept":91,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,2,1],[1,2,1,7],[1,8,1,13],[90,0,90,1]]}
["Table 57:  Status of Mutual Funds Industry in India "]
["Sr. No.","Scheme Category","2019-20",null,null,null,null,null,"2020-21$"]
[null,null,"No. of schemes ","No. of Folios ","Funds mobilized  (₹ crore)","Repurchase/ Redemptio  (₹ crore)","Net Inflow (+ve)/ Outflow (-ve)   (₹ crore)","Net Assets Under Management as on  (₹ crore)","No. of schemes ","No. of Folios ","Funds mobilized  (₹ crore)","Repurchase/ Redemptio  (₹ crore)","Net Inflow (+ve)/ Outflow (-ve)   (₹ crore)","Net Assets Under Management as on  (₹ crore)"]
["A","Open ended Schemes"]
["I","Income/Debt Oriented Schemes"]
[1,"Overnight Fund",30,86255,3104154.0667759995,3036499.7779539716,67654.28882202816,80174.192291984597,30,115313,1944626.9477434577,1953352.8869106753,-8725.9391672172278,72862.127995851493]
[2,"Liquid Fund",39,1815547,14430056.329323001,14505186.054505004,-75129.725182001814,334725.3213015318,39,2149311,2282258.6952072331,2243893.8647425887,38364.83056464453,383000.13651501166]
[3,"Ultra Short Duration Fund",29,650202,185685.09487737255,195237.94583798823,-9552.8509606156586,72226.364568975245,29,710651,108951.76409405333,85913.23185070233,23038.532243351005,99158.582463316372]
[4,"Low Duration Fund",26,963640,127452.33041418077,136233.17545214473,-8780.8450379639798,81371.187137965753,26,1084489,147142.16104746499,110184.93396645298,36957.227081012003,123035.71171584085]
[5,"Money Market Fund",20,350429,193476.63954390472,193561.71436373022,-85.074819825480972,57016.643850834022,19,446519,149364.46196459097,113311.75288077601,36052.709083814945,95678.480766076624]
[6,"Short Duration Fund",28,359856,60309.593780412593,51733.484357941859,8576.1094224707285,93444.339442586293,26,550385,97745.555208214704,58973.620287135614,38771.934821079092,138728.48948993318]
[7,"Medium Duration Fund",18,221149,7325.8834682326251,17778.474863760603,-10452.591395527979,28290.289846830285,19,274189,7545.1140145571571,11403.564203853002,-3858.450189295841,25294.007103727276]
[8,"Medium to Long Duration Fund",14,108506,2086.6459060477173,3147.5747499203171,-1060.9288438725998,9804.7908106611922,14,119098,3816.3968947393491,2560.9436187656379,1255.4532759737108,11772.299761830296]
[9,"Long Duration Fund",2,27215,628.5458478581354,278.32056125400004,350.22528660413542,1669.5749464186913,2,30400,1204.8719862720247,524.24730526099995,680.62468101102479,2476.4780414318002]
[10,"Dynamic Bond Fund",29,215543,5571.706000654719,8309.8008656759994,-2738.0948650212804,18115.974121491414,28,277446,10794.169427758825,5920.3481531851994,4873.8212745736255,24091.369038829249]
[11,"Corporate Bond Fund",20,391721,49845.542744406193,31577.580181540001,18267.962562866192,81729.798821482749,21,609390,82799.036479186834,34427.476504051003,48371.559875135834,137346.4700403758]
[12,"Credit Risk Fund",23,461927,9276.4142857952484,37303.949861584064,-28027.535575788814,55380.524188531796,22,373528,1501.2706226255011,29585.272704212995,-28084.002181587501,28224.790557618544]
[13,"Banking and PSU Fund",19,170392,59782.85583444596,25271.312635743183,34511.54319870277,72475.856660864214,21,335378,86700.323314656445,46794.533194088748,39905.790220567687,118538.35244454931]
[14,"Gilt Fund",21,116938,5879.9775928194576,5170.9811173282751,708.99647549118345,9284.9759829144186,21,210382,18006.498102124271,8072.7997106917774,9933.6983914324937,20085.867284272073]
[15,"Gilt Fund with 10 year constant duration",4,34206,789.05916811300006,446.77712390199997,342.28204421099997,941.41219401438013,4,54975,831.58266879776045,409.09408547700002,422.48858332076043,1445.1086643826175]
[16,"Floater Fund",7,162058,36316.737786070204,35678.485120826008,638.25266524420385,32490.431134149123,8,183702,41301.450054438559,23314.453096157999,17986.996958280564,52743.12868488102]
[null,"Sub total - I (1+2+3+4+5+6+7+8+9+10+11+12+13+14+15+16)",329,6135584,18278637.423349313,18283415.40955231,-4777.9862029992328,1029141.6773012358,329,7525156,4984590.2988301739,4728643.0232140757,255947.27551609668,1334481.4005679281]
[]
["II","Growth/Equity Oriented Schemes"]
[17,"Multi Cap Fund",34,9264215,45594.025753337883,30033.961169581464,15560.064583756426,113908.48534887873,35,9541468,18480.296569369013,22496.176883320815,-4015.8803139517963,145394.97984038881]
[18,"Large Cap Fund",29,10028315,49942.58972327716,33939.253940046889,16003.335783230275,113541.25340863605,31,10393288,21741.564007369328,21752.843178843414,-11.279271474083345,148964.21810774607]
[19,"Large & Mid Cap Fund",27,4735650,17834.196607885489,12541.878803005366,5292.3178048801228,42971.995422114334,28,4842392,9288.5523757665269,7905.8138111809785,1382.7384645855482,59843.84202175129]
[20,"Mid Cap Fund",27,6498964,30246.469627091439,16729.014988343733,13517.454638747702,65804.848930772045,26,6488602,10929.215016232292,11920.885565490637,-991.67054925834145,90405.810680103459]
[21,"Small Cap Fund",23,5128434,21544.745674487225,11113.774490803877,10430.97118368335,35832.031286181911,23,5040550,7858.1172519992815,7477.9380932433114,380.17915875597004,53493.439415558307]
[22,"Dividend Yield Fund",6,470525,365.86219874400001,743.54862671499995,-377.686427971,3282.0084482292932,6,453662,146.49769950628303,315.19264776299997,-168.694948256717,4108.5741143229552]
[23,"Value Fund/Contra Fund",17,4131763,12840.084762151177,14770.547673972873,-1930.4629118216969,39459.523672551848,17,3950485,4593.2458887761204,7514.3312777763613,-2921.0853890002395,52203.310825195258]
[24,"Focused Fund",22,3570651,23485.73361535052,10650.821706157074,12834.911909193448,39071.922440695627,24,3757996,10239.556028104236,7315.9121199551391,2923.6438081490978,54256.325679207475]
[25,"Sectoral/Thematic Funds",96,6528979,20900.560135889402,16631.597691730614,4268.9624441587839,49844.160506678665,97,7042517,13829.329214253681,10682.714922414421,3146.6141918392605,68706.354610339287]
[26,"ELSS",43,12335172,17429.36016490576,9242.2797320221853,8187.0804328835711,74791.498748658283,42,12434533,7285.8288816577369,5239.689168024488,2046.1398136332507,99915.35179045012]
[null,"Sub total - II (17+18+19+20+21+22+23+24+25+26)",324,62692668,240183.62826312004,156396.67882237906,83786.94944074098,578507.72821339685,329,63945493,104392.20293303451,102621.49766801258,1770.7049650219494,777292.20708506298]
[]
["III","Hybrid Schemes"]
[27,"Conservative Hybrid Fund",22,386103,1165.5897263883048,4894.8240683645736,-3729.2343419762683,11189.68047502978,22,377938,1355.9911148409917,2439.2196714934803,-1083.2284566424987,11274.463794121824]
[28,"Balanced Hybrid Fund/Aggressive Hybrid Fund",33,5272614,27229.243232883091,48781.129242591043,-21551.886009707967,100990.17902722374,33,5014263,6986.9037973439617,19468.57083549428,-12481.66703814032,110994.02449519913]
[29,"Dynamic Asset Allocation/Balanced Advantage",23,2657247,29572.946994399783,23497.174200168731,6075.7727942310557,77091.389533361667,23,2683188,9233.7375688667471,12910.395194652632,-3676.6576257858856,87324.661771391548]
[30,"Multi Asset Allocation",8,631330,4243.5340999724831,3490.0690572085082,753.46504276397502,9439.4050171137987,10,725253,2263.9917600701519,1792.0499952671692,471.94176480298313,12067.766115246572]
[31,"Arbitrage Fund",25,296071,86320.86078416559,84637.864433798328,1682.9963503672657,52210.302000569289,27,388682,47002.257701436014,32341.599840796269,14660.657860649746,63847.695945164189]
[32,"Equity Savings Fund",23,329350,2447.9156112412593,9445.474456471793,-6997.558845230531,11228.912211943523,23,304393,655.17942750866916,3355.1616027341315,-2699.9821752254616,9953.655221420915]
[null,"Sub total - III (27+28+29+30+31+32)",134,9572715,150980.09044905051,174746.535458603,-23766.44500955247,262149.86826524179,138,9493717,67498.061370066542,72306.997140437961,-4808.9356703414342,295462.26734254416]
[]
["IV","Solution Oriented  Schemes"]
[33,"Retirement Fund",24,2544753,3155.4759845799999,1113.0925893046999,2042.3833952753,8507.0652043591217,24,2546876,1023.1697675777111,779.06957545399996,244.10019212371122,10647.819688751579]
[34,"Childrens' Fund",9,2892087,851.94797451082786,440.18600094256954,411.76197356825855,7192.1791421455637,10,2892151,417.28058750076622,172.93680213687188,244.34378536389428,9128.8838205754018]
[null,"Sub total - IV (33+34)",33,5436840,4007.4239590908278,1553.2785902472694,2454.1453688435586,15699.244346504685,34,5439027,1440.4503550784773,952.00637759087181,488.44397748760548,19776.703509326981]
[]
["V","Other Schemes"]
[35,"Index Funds",32,544075,8221.7278099505056,3205.0868115734311,5016.6409983770745,8088.996682432592,37,766350,5675.8045715867765,3850.7137341325833,1825.0908374541932,13070.639041227698]
[36,"GOLD ETFs",11,526671,2514.7871980499999,901.19522454427681,1613.5919735057232,7949.0628744751848,11,782861,5395.3335156029998,544.62385770734704,4850.7096578956525,13969.059103716922]
[37,"Other ETFs",76,1899781,123007.73807137753,63198.326308484517,59809.411762893018,146462.67481179998,85,3142053,51480.255365635989,30847.766116007413,20632.489249628579,210277.81858838114]
[38,"Fund of funds investing overseas",28,189784,1392.9029335969999,522.36335582007507,870.53957777692483,2734.3551154855036,29,439853,3899.7545106048783,938.85838993848552,2960.8960206663928,6781.9470945357316]
[null,"Sub total - V (35+36+37+38)",147,3160311,135137.15601297506,67826.971700422306,67310.184312552752,165235.08948419325,162,5131117,66451.147963430645,36181.962097785829,30269.185765644819,244099.46382786147]
[]
[null,"Total A-Open ended Schemes",967,86998118,18808945.722033549,18683938.874123961,125006.84790958559,2050733.6076105726,992,91534510,5224372.161451784,4940705.4864979032,283666.67455390963,2671112.0423327237]
[]
["B","Close  Ended Schemes"]
["I","Income/Debt Oriented Schemes",815,1042672,4503.0041427139995,38312.8953746568,-33809.891231942805,150622.75938203395]
["i","Fixed Term Plan",742,851658,4013.9855413139999,32726.769196192003,-28712.783654878,140594.52457520913,588,523167,76.441790505,29875.491596159001,-29799.049805654005,118002.5268256921]
["ii","Capital Protection Oriented  Schemes",31,107535,489.01860140000002,2665.4728133068024,-2176.4542119068024,4209.97686122907,22,59828,0,1867.8374759739984,-1867.8374759739984,2577.2742904003117]
["iii","Infrastructure Debt Fund ",9,89,0,314.72242813100002,-314.72242813100002,2391.3706024945245,9,89,0,0,0,2367.8833964691285]
["iv","Other Debt",33,83390,0,2605.9309370270003,-2605.9309370270003,3426.8873431012225,9,18947,0,2875.9384673089999,-2875.9384673089999,760.75102924452926]
[null,"Sub total (i+ii+iii+iv)",815,1042672,4503.0041427139995,38312.8953746568,-33809.891231942805,150622.75938203395,628,602031,76.441790505,34619.267539442,-34542.825748937008,123708.43554180606]
[]
["II","Growth/Equity Oriented Schemes",111,1701373,3.999999999999837E-5,2190.4230618150009,-2190.4230218150005,24453.849414134409]
["i","ELSS",25,470566,0,322.09820754499998,-322.09820754499998,3044.9470239677185,25,460345,0,116.59526017099999,-116.59526017099999,4010.9212462126052]
["ii","Others",86,1230807,3.999999999999837E-5,1868.3248542700007,-1868.3248142700006,21408.902390166691,74,1118440,-1.0000000000000001E-5,3149.2941244390008,-3149.294134439001,23744.219897422863]
[null,"Sub total (i+ii)",111,1701373,3.999999999999837E-5,2190.4230618150009,-2190.4230218150005,24453.849414134409,99,1578785,-1.0000000000000001E-5,3265.8893846100009,-3265.8893946100011,27755.141143635468]
[]
["III","Other Schemes",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total B -Close ended Schemes",926,2744045,4503.0041827139994,40503.318436471804,-36000.31425375781,175076.60879616835,727,2180816,76.441780504999997,37885.156924052004,-37808.715143547008,151463.57668544154]
[]
["C","Interval Schemes"]
["I","Income/Debt Oriented Schemes",23,3888,9.0477382380000044,1714.7554145029999,-1705.7076762649999,392.64872913278566,23,3665,3.6043487429999992,38.374259815999999,-34.769911072999996,365.255318816981]
[]
["II","Growth/Equity Oriented Schemes",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["III","Other Schemes",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total C -Interval Schemes",23,3888,9.0477382380000044,1714.7554145029999,-1705.7076762649999,392.64872913278566,23,3665,3.6043487429999992,38.374259815999999,-34.769911072999996,365.255318816981]
[]
["Grand Total (A+B+C)","Grand Total (A+B+C)",1916,89746051,18813457.7739545,18726156.947974935,87300.825979562796,2226202.8651358737,1742,93718991,5224452.2075810321,4978629.017681771,245823.18949928961,2822940.8743369821]
[]
[null,"Fund of Funds Scheme (Domestic)",46,637072,10813.35154536839,1930.1320254151196,8883.2195199532707,12257.11304643228,49,991068,8954.7619434625358,3097.8155269198828,5856.9464165426543,20603.550282453492]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: SEBI."]

{"sheet":"58","index":58,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,6],[0,0,0,8],[2,0,3,0],[2,1,2,3],[2,4,2,6],[2,7,2,9],[14,0,14,6]]}
["Table 58: Trends in Transactions on Stock Exchanges by Mutual Funds"]
[null,null,null,null,null,null,null,null,null," (₹ crore)"]
["Year/  Month","Equity",null,null,"Debt",null,null,"Total"]
[null,"Gross Purchases","Gross Sales","Net Purchases /Sales","Gross Purchases","Gross Sales","Net Purchases /Sales","Gross Purchases","Gross Sales","Net purchases /Sale"]
["2019-20","8,06,744","7,15,142",91603,"22,63,317","18,44,703","4,18,614","30,70,061","25,59,845","5,10,216"]
["2020-21$",{"$f":"SUM(B7:B13)","v":427103.54},{"$f":"SUM(C7:C13)","v":465121.19},-38017.649999999994,1045186.6699999999,898524.58,146662.09,1472290.21,1363645.7699999998,108644.44]
["Apr-20",54525.1,62490.6,{"$f":"B7-C7","v":-7965.5},121444.56,131239.1,{"$f":"E7-F7","v":-9794.5400000000081},175969.66,193729.7,{"$f":"H7-I7","v":-17760.040000000008}]
["May-20",70794.759999999995,64272.31,6522.45,139959.84,129260.47,10699.37,210754.6,193532.78,17221.82]
["Jun-20",73265.58,73767.08,-501.5,179002.03,137637.32,41364.71,252267.61,211404.4,40863.21]
["Jul-20",61103.69,70298.73,-9195.0400000000009,171073.17,139175.32,31897.85,232176.86,209474.05,22702.81]
["Aug-20",55152.49,63552.13,-8399.64,139359.72,114865.98,24493.74,194512.21,178418.11,16094.1]
["Sep-20",63901.29,68035.66,-4134.37,151055.35999999999,134050.39000000001,17004.97,214956.65,202086.05,12870.6]
["Oct-20",48360.63,62704.68,-14344.05,143291.99,112296,30995.99,191652.62,175000.68,16651.939999999999]
["Notes -"]
["$ indicates as on October 31, 2020"]
["Source: SEBI"]

{"sheet":"59","index":59,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,0,4,8]]}
["Table 59: Assets Managed by Portfolio Managers"]
["Year / Month","2019-20",null,null,null,"2020-21$"]
["Particulars","Discretionary","Non-Discretionary","Advisory","Total","Discretionary#","Non-Discretionary","Advisory**","Total"]
["No. of Clients",138829,6853,4038,149720,146813,8722,2410,{"$f":"F4+G4+H4","v":157945}]
["AUM (₹ crore)"]
["Listed Equity",111995.61,18477.080000000002,0,130472.69,128392.34300000001,20917.239999999998,0,{"$f":"SUM(F6:H6)","v":149309.58300000001}]
["Unlisted Equity",458.85,74.69,0,533.54,472.55300000000005,148.05000000000001,0,{"$f":"SUM(F7:H7)","v":620.60300000000007}]
["Plain Debt",1160856.72,74701.850000000006,0,1235558.57,1458596.102,82082.285000000003,0,1540678.3869999999]
["Structured Debt",752.86,530.57000000000005,0,1283.43,1339.75,1335.1369999999999,0,2674.8869999999997]
["Equity Derivatives",466.12,-1.24,0,464.88,533.51199999999994,0,0,533.51199999999994]
["Mutual Funds",14112.76,13856.15,0,27968.91,13072.173999999992,11978.798000000001,0,25050.971999999994]
["Others",14498.29,1392.08,0,15890.37,8676.219000000001,4088.4390000000003,0,12764.658000000001]
["Total*",1303141.21,109031.18,193620,1605792.39,1611082.6529999999,120549.94899999999,172202.198,{"$f":"SUM(F13:H13)","v":1903834.8}]
["Notes:"]
["1. **Value of Assets for which Advisory Services are being given. "]
["2. #of the above AUM Rs. 14,50,213.83/- Crores are contributed by funds from EPFO/PFs."]
["3.  The above data is based on the monthly report received from Portfolio Managers."]
["$ indicates up to September 30, 2020"]
["Source: SEBI."]

{"sheet":"60","index":60,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[9,11,9,12],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,12],[2,11,2,12],[3,11,3,12],[4,11,4,12],[5,11,5,12],[6,11,6,12],[7,11,7,12],[8,11,8,12],[16,11,16,12],[17,0,17,11],[19,0,19,11],[10,11,10,12],[11,11,11,12],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[18,0,18,6]]}
["Table 60: Progress Report of NSDL & CDSL as on end of Jul-20 (Listed Companies)"]
["Parameter","Unit","NSDL",null,null,null,null,"CDSL"]
[null,null,"Oct-20","Sep-20","Oct-19","% Change during the year","% Change during the month","Oct-20","Sep-20","Oct-19","% Change during the year","% Change during the month"]
["Number of companies signed up to make their shares available for dematerialization","Number",5651,5633,5665,-0.247131509,0.31954553499999999,5734,5718,5633,1.79,0.28000000000000003,null,"Number of companies signed up to make their shares available for dematerialization"]
["Number of Depository Participants (registered)","Number",278,277,277,0.36101083,0.36101083,591,593,600,-1.5,-0.34,null,"Number of Depository Participants (registered)"]
["Number of Clearing Corporations (connected)","Number",4,4,3,33.333333332999999,0,3,3,3,0,0,null,"Number of Stock Exchanges (connected)"]
["Number of Investors Accounts","Lakh",205.85,204.56,204.88246000000001,0.47224149900000001,0.63062182200000005,270.41000000000003,261.27999999999997,191.2,41.43,3.49,null,"Number of Investors Accounts"]
["Quantity of Shares dematerialized","Crore",55719.584557200003,55613.675105599999,53661.9019367,3.8345316629999999,0.190437786,23608.87,23468.49,21100.82,11.89,0.6,null,"Quantity of Shares dematerialized"]
["Value of Shares dematerialized","Crore",13848796.7330314,13565291.6293015,13426845.0477497,3.1425974139999999,2.0899300319999998,1711021.11,1699270.5,1749217.13,-2.1800000000000002,0.69,null,"Value of Shares dematerialized"]
["Quantity of Securities dematerialized #","Crore",60119.095985840999,60077.365401807998,57846.385406697998,3.9288722420000002,6.9461408000000002E-2,25988.91,25779.3,22920.55,13.39,0.81,null,"Quantity of Securities dematerialized #"]
["Value of Securities dematerialized #","Crore",17252274.013185602,16994230.049920298,16317974.7805367,5.7255832609999997,1.518421032,1886366.74,1870606.19,1888170.54,-0.1,0.84,null,"Value of Securities dematerialized #"]
["Quantity of shares settled during the month","Crore",926.98,1444.7983184,924.74872949999997,0.24128397600000001,-35.840180031000003,1167.29,1769.75,546.54,113.58,-34.04,null,"Quantity of shares settled during the month"]
["Average Quantity of shares settled daily (quantity of shares settled during the month)","Crore",46.35,65.672650836000003,46.237436475000003,0.243446725,-29.422675330000001,37.65,58.99,17.63,113.58,-36.17,null,"Average Quantity of shares settled daily (quantity of shares settled during the month (divided by 30))"]
["Value of shares settled during the month in dematerialized form","Crore",232311.96,335093.59488625801,229735.501742102,1.1214889459999999,-30.672515516000001,117420.57,151225.93,57664.800000000003,103.63,-22.35,null,"Value of shares settled during the month in dematerialized form"]
["Average Value of shares settled daily (value of shares settled during the month)","Crore",11615.6,15231.527040285,11486.775087104999,1.121506358,-23.739753937,3787.76,5040.8599999999997,1860.15,103.63,-24.86,null,"Average Value of shares settled daily (value of shares settled during the month (divided by 30))"]
["Training Programmes conducted for representatives of Corporates, DPs and Brokers","Number",2,6,5,-60,-66.666666667000001,0,0,55,0,0,null,"Training Programmes conducted for representatives of Corporates, DPs and Brokers"]
["The ratio of dematerialized equity shares to the total outstanding shares market value","per cent",88.05,87.9,86.980067543000004,1.2300892459999999,0.170648464,10.96,11.08,11.37,-3.63,-1.1000000000000001,null,"The ratio of dematerialized equity shares to the total outstanding shares (market value)"]
["Notes: 1. Shares includes only equity shares. 2. Securities include common equity shares, preference shares, debenture, MF units, etc. 3. No. of days taken for calculating Daily Average is 30 days instead of Actual settlement days. 4. Quantity and value of shares mentioned are single sided. 5. #Source for listed securities information: Issuer/ NSE/BSE."]
["$ indicates as on October 31, 2020"]
["Source: NSDL and CDSL."]

{"sheet":"61","index":61,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,7],[0,0,0,9],[1,0,2,0],[1,1,1,5],[1,6,1,10],[12,0,12,7],[13,0,13,7],[14,0,14,6]]}
["Table 61: Progress of Dematerialisation at NSDL and CDSL (Listed and Unlisted Companies)"]
["Year/ Month","NSDL",null,null,null,null,"CDSL"]
[null,"Companies Live","DPs Live","DPs\nLocations","Demat \nQuantity \n(million securities)","Demat Value (₹ crore)","Companies Live","DPs Live","DPs\nLocations","Demat \nQuantity \n(million securities)","Demat Value  (₹ crore)"]
["2019-20",30335,279,30874,2351602.9900000002,16032791.785,14762,599,20352,455726.55,1671972.37]
["2020-21$",{"$f":"B12","v":32285},{"$f":"C12","v":278},31241,2371425.25,19989147.899999999,15662,591,20706,457347.94,2092306.68]
["Apr-20",30366,280,30948,2354838.66,18960841.862,38546,595,20519,438715.09,1844619.85]
["May-20",30425,280,30971,2175115.25,17045667.539999999,14818,596,20548,437804.87,1844324.8]
["Jun-20",30594,278,30989,2183559.2999999998,18075718.438999999,14891,597,20589,439758.12,2042069.83]
["Jul-20",30802,278,31024,2283349.31,19011716.522999901,15011,597,20672,445417.07,2068009.11]
["Aug-20",31125,277,31065,2301443.69,19610998.636,15144,594,20689,448038.24,2147565.27]
["Sep-20",31800,277,31221,2330889.2799999998,19770287.741999902,15455,593,20694,454306,2077006.8529999999]
["Oct-20",32285,278,31241,2371425.25,19989147.899999999,15662,591,20706,457347.94,2092306.68]
["Notes : 1. For CDSL, the current and historical data of Companies Live has been revised to exclude MF schemes count. 2. The Companies Live figure  includes only the number of mutual fund companies and not the mutual fund schemes. 3. DPs Locations represents the total live (main DPs and branch DPs as well as non-live (back office connected collection centres)."]
["* Includes Nine Participants which are under closure/termination process and SEBI registration is not yet cancelled/suspended"]
["$ indicates as on October 31, 2020"]
["Source: NSDL and CDSL."]

{"sheet":"62","index":62,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[3,0,3,9],[10,0,10,9],[17,0,17,9],[19,0,19,9],[18,0,18,9]]}
["Table 62: Depository Statistics"]
["Particulars","Unit","Debt",null,"Equity",null,"Others",null,"Total"]
[null,null,"Listed","Unlisted","Listed","Unlisted","Listed","Unlisted","Listed","Unlisted"]
["NSDL"]
["No.of issuers debt/Companies(equity)","(numbers)",840,2166,5651,23066,225,5040,6716,30272]
["No.of Active Instruments","(numbers)",8992,8423,11459,24748,4868,26673,25319,59844]
["Demat Quantity","(lakhs)",114266.80561,654528.50353999995,5571958.45572,11106936.152559999,325684.33725406998,5940878.3389159301,6011909.5985840699,17702342.995015901]
["Demat Value","(Rs.crore)",2884408.67262926,596592.35163895797,13848796.7330314,1052493.0338843199,519068.60752490099,1087788.5016376299,17252274.013185602,2736873.8871609]
["Quantity settled during the month","(Lakh)",1677.29276,1981.8586700000001,92697.515100000004,1.68,1210.2283661199999,87.196309999999997,95585.036226120006,2070.7349800000002]
["Value Settled during the month","(Rs.crore)",141847.2860539,6964.0398876999998,232311.96033759799,0.67305000000000004,1611.2157497999999,245.72518533100001,375770.46214129799,7210.438123031]
["CDSL"]
["No. of Issuers (Debt) / Companies (Equity)","(numbers)",602,467,5734,8682,2487,702,8823,9851]
["No. of Active Instruments","(numbers)",7273,3907,5873,8985,20389,2250,33535,15142]
["Demat Quantity","(lakh)",3504.83,114597.57,2360886.84,1716208.6,234499.11,143782.47,2598890.7799999998,1974588.64]
["Demat Value","(Rs.crore)",73191.460000000006,43627.14,1711021.11,135264.28,102154.18,27048.52,1886366.74,205939.93]
["Quantity settled during the month","(lakh)",28.41,0,116728.87,0,26337.54,0,143094.81,0]
["Value Settled during the month","(Rs.crore)",623.37,0,117420.57,0,13482.79,0,131526.73000000001,0]
["Note: The categories included in Others are Preference Shares, Mutual Fund Units, Warrants, PTCs, Treasury Bills, CPs, CDs and Government Securities."]
["$ indicates as on October 31, 2020"]
["Source: NSDL and CDSL."]

{"sheet":"63","index":63,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[15,0,17,0],[1,0,2,0],[1,1,2,1],[1,2,1,7],[1,8,1,11],[3,0,5,0],[6,0,8,0],[9,0,11,0],[12,0,14,0]]}
["Table 63: Number of commodities permitted and traded at exchanges"]
["Exchanges","Particulars","Futures",null,null,null,null,null,"Options"]
[null,null,"Agriculture","Metals other than bullion","Bullion ","Energy ","Gems and Stones","Indices","Agriculture","Metals other than bullion","Bullion ","Energy "]
["NCDEX","Permitted for trading",22,1,0,0,0,1,7,0,0,0]
[null,"Contracts floated ",21,0,0,0,0,6,7,0,0,0]
[null,"Traded",17,0,0,0,0,2,2,0,0,0]
["MCX","Permitted for trading",7,5,2,2,0,2,0,2,2,1]
[null,"Contracts floated ",7,5,2,2,0,2,0,2,2,1]
[null,"Traded",5,5,2,2,0,2,0,2,2,1]
["ICEX","Permitted for trading",10,1,0,0,1,0,0,0,0,0,null," "]
[null,"Contracts floated ",10,1,0,0,1,0,0,0,0,0]
[null,"Traded",1,0,0,0,1,0,0,0,0,0]
["BSE","Permitted for trading",8,3,2,2,0,0,0,0,2,0,null,null,null,null," "]
[null,"Contracts floated ",8,3,2,2,0,0,0,0,2,0]
[null,"Traded",2,0,1,0,0,0,0,0,2,0,null,null," "]
["NSE","Permitted for trading",1,1,"2 ",1,0,0,0,1,2,0]
[null,"Contracts floated ",0,0,"2 ",1,0,0,0,0,2,0]
[null,"Traded",0,0,1,0,0,0,0,0,1,0]
["Source: NCDEX, MCX, ICEX, BSE and NSE",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"64","index":64,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[15,0,15,8],[0,0,0,8],[1,0,2,0],[1,1,1,4],[1,5,1,8],[14,0,14,8]]}
["Table 64: Trends in Commodity Indices"]
["Year/  Month","MCX  INDEX",null,null,null,"Nkrishi NCDEX INDEX"]
[null,"Open","High","Low","Close","Open","High","Low","Close"]
["2019-20 @ MCX COMDEX",3662.99,4172,3312,3739,3051.23,3590,2838,3414]
["2019-20 @@ MCX   iCOMDEX",10576,10951,7662.5,8255.52,3450.3,3674,2841.01,3179.85]
["2020-21$ ",8252.44,10649.58,7866.92,{"$f":"E13","v":9873.66},3176.19,3627.98,3027.91,{"$f":"I13","v":3757.53}]
["2020-04-01",8252.44,8848.23,7866.92,8007.17,3176.19,3266.84,3027.91,3173.55]
["2020-05-02",8008.34,8720.91,7994.73,8705.89,3173.55,3233.2,3121.31,3188.11]
["2020-06-03",8707.2099999999991,9102.58,8664.18,9089.06,3188.11,3343.94,3187.68,3238.66]
["2020-07-04",9090.0400000000009,10047.24,8971.64,10001.06,3238.66,3300.47,3219.8,3265.1]
["2020-08-05",10001.56,10649.58,9773.19,10227.33,3265.1,3586.59,3262.37,3582.76]
["2020-09-06",10232.200000000001,10320.48,9540,9714.1,3582.76,3627.98,3427.34,3614.93]
["2020-10-07",9716,10117.290000000001,9545.2900000000009,9873.66,3614.93,3775.65,3606.34,3757.53]
["$ indicates as on October 31, 2020"]
["Note : For the F.Y. 2018-19, MCX Index data pertains to MCX COMDEX."]
["Note : For the F.Y. 2018-19, MCX Index data pertains to MCX COMDEX."]
["Source: MCX and NCDEX",null,null,null," ",null,null," "]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"65","index":65,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,14],[0,15,0,16],[2,0,3,0],[2,1,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,2,13],[1,0,1,23],[2,22,2,23],[2,14,2,16],[2,17,2,19],[2,20,2,21],[15,0,15,17],[16,0,18,0],[16,1,18,1],[16,2,16,5],[16,6,16,9],[16,10,16,13],[16,14,16,15],[17,17,18,17],[31,0,31,9],[16,16,16,17],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,18,14],[17,15,18,15],[17,16,18,16]]}
["Table 65: Trends in Commodity Derivatives at MCX "]
["Futures"]
["Year/  Month","No.of Trading days","Agriculture",null,null,"Metals",null,null,"Bullion",null,null,"Energy",null,null,"BULLDEX Index ",null,null,"METALDEX Index",null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Volume ('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 tonnes)*","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 lots)**","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 lots)**","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)"]
["2019-20",259,11353.453030000001,1789350,100919.4925252,54812.698150000004,37596650,1568294.4711345003,267.94053898599998,50829084,2915533.5630957996,1188816.1945911769,205480778,3813027.4302929998,"NA","NA","NA","NA","NA","NA",295695862,8397774.9570485,148505,11002.5757954]
["2020-21$",{"$f":"SUM(B7:B13)","v":148},{"$f":"SUM(C7:C13)","v":5470.9952499999999},629811,41182.301058600009,21610.539000000001,8453514,832701.45744500018,254.66281518300002,67387187,2766965.3687521005,233141.96790988999,44189649,973431.74966249999,155.23400000000001,155234,12211.253144999999,10.741999999999999,10742,658.51666999999998,120826137,4627150.6467332002,{"$f":"W13","v":168203},{"$f":"X13","v":14247.269590899999}]
["2020-04-01",18,517.98455999999999,66294,3671.8557304000001,1396.8564999999999,1107524,43536.21014749998,12.250992582999997,3589671,143017.30427060003,54865.717030205,5858278,91621.074682499981,"NA","NA","NA","NA","NA","NA",10621767,281846.444831,122686,11614.037363900001]
["2020-05-02",21,617.41380000000015,76863,4106.3184176000004,2275.9254999999998,1497418,79117.77099249998,27.946811002000004,7175006,296836.62684469996,37857.340248795001,6228088,118996.56378499998,"NA","NA","NA","NA","NA","NA",14977375,499057.28003979998,135281,14295.7603913]
["2020-06-03",22,877.94938000000013,104714,6367.6581902000007,3261.317500000001,1057395,115127.8131625,37.021260684000005,9153415,364906.40945049998,39902.8655172,6570596,143533.84207250003,"NA","NA","NA","NA","NA","NA",16886120,629935.72287569998,152305,14749.869857399999]
["2020-07-04",23,989.46590000000015,114651,7277.3962512000026,3745.4299999999989,1253701,149118.7076275,57.357698916999993,13030913,559967.59815910039,30250.286932489998,6432779,137758.02345750001,"NA","NA","NA","NA","NA","NA",20832044,854121.72549530037,144727,15233.6824719]
["2020-08-05",21,742.65032999999971,82203,5824.4504842000024,3733.9474999999998,1216867,152687.29222500001,53.480413654000024,14921463,626980.10613599978,21521.773845489999,4927161,123009.16329750004,26.303999999999998,26304,2119.6345099999999,"NA","NA","NA",21173998,910620.6466526998,164840,17478.619636200001]
["2020-09-06",22,858.71834999999965,90864,6838.5318600000001,3672.4005000000006,1176532,146911.16517500006,34.474819904000022,10281771,422378.63415189995,24137.626543720002,7268301,171492.34703249999,65.662000000000006,65662,5182.9009949999991,"NA","NA","NA",18883130,752803.57921440003,158034,13881.9313588]
["2020-10-07",21,866.81292999999971,94222,7096.0901250000006,3524.6615000000011,1144077,146202.49811500005,32.130818439000002,9234948,352878.68973930023,24606.357791989998,6904446,187020.73533499998,63.267999999999994,63268,4908.7176399999989,10.741999999999999,10742,658.51666999999998,17451703,698765.2476243003,168203,14247.269590899999]
[]
[]
["Options"]
["Year / \nMonth","No.of Trading days","Metals",null,null,null,"Bullion",null,null,null,"Energy",null,null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Call Options ",null,"Put Options ",null,"Call Options ",null,"Put Options ",null,"Call Options ",null,"Put Options ",null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Notional Value \n(₹ crore)"]
[null,null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)"]
["2019-20",259,18146,1293.2336039999998,12977,969.92868200000009,251533,74410.1388935,278935,90244.629649500013,1729784,69961.987244000004,1393470,54862.742491999998,3684845,291742.67056500004,11844,698.07970150000006]
["2020-21$",{"$f":"SUM(B22:B28)","v":148},{"$f":"SUM(C22:C28)","v":183},22.70496,313,32.442229499999996,126477,44228.573671999999,173958,60642.021980999998,421851,11786.596163000002,346596,{"$f":"SUM(N22:N28)","v":8978.7570179999984},{"$f":"SUM(O22:O28)","v":1069378},125691.09602349999,{"$f":"Q28","v":9650},{"$f":"R28","v":2388.1539930000004}]
["2020-04-01",18,3,0.32998,9,0.89101249999999999,6999,1968.6774660000001,10944,3679.8237015,90838,1914.003608,55438,933.48083799999995,164231,8497.2066059999997,11690,1651.0206595]
["2020-05-02",21,31,3.2268599999999998,120,11.252795000000001,11114,4286.8298429999995,22893,8974.6587314999997,62769,1473.6085619999999,65421,1300.1379899999999,162348,16049.714781499999,7927,816.22000949999995]
["2020-06-03",22,11,1.2382219999999999,15,1.6099969999999999,14448,4216.118058,19882,6425.0760920000002,77698,2375.3497889999999,74545,2119.2725380000002,186599,15138.664696,7860,1559.11]
["2020-07-04",23,52,6.4820539999999998,114,13.358575999999999,16126,5916.5598620000001,33590,11775.034136999999,54977,1749.6879269999999,52671,1603.4092559999999,157530,21064.531812000001,7882,1184.07]
["2020-08-05",21,51,6.7336830000000001,43,3.76247,31320,11674.081338,45055,14320.374709,51453,1688.743729,41167,1304.5440189999999,169089,28998.239947999999,9062,3026.3053569999997]
["2020-09-06",22,22,2.912236,7,0.90368099999999996,31513,12055.351627,27693,11639.881839000003,46984,1450.5074050000001,29288,877.65585099999998,135507,26027.212639000005,7154,1279.0107834999999]
["2020-10-07",21,13,1.781925,5,0.66369800000000001,14957,4110.9554779999999,13901,3827.1727709999996,37132,1134.6951429999999,28066,840.25652600000001,94074,9915.5255409999991,9650,2388.1539930000004]
["$ indicates as on October 31, 2020"]
["Note : 1. Natural Gas volume is in Trillion BTU and is not included in volume (\"000 tonnes\") of energy contracts."]
["           2. Options includes both options on futures and goods."]
["Source: MCX"]

{"sheet":"66","index":66,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,12,1,19],[2,2,2,4],[2,5,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[2,18,2,19],[0,0,0,4],[0,5,0,6],[1,0,4,0],[1,1,4,1],[1,2,1,11],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,19,4,19],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18]]}
["Table 66: Trends in Commodity Derivatives at NCDEX "]
["Year/  Month","No.of Trading days","Futures",null,null,null,null,null,null,null,null,null,"Options"]
[null,null,"Agriculture ",null,null,"Agridex Index ",null,null,"Total ",null,"Open interest at the end of the period",null,"Call options ",null,"Put options ",null,"Total ",null,"Open interest \n  at the end of the period"]
[null,null,"Volume\n('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume\n('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Notional Value\n(₹ crore)"]
[]
["2019-20",247,95258.745999999999,13080142,441966.96943999996,"Na","Na","Na","Na","Na",93073,2262.96,1518,41.410000000000004,22,0.74,{"$f":"M6+O6","v":1540},42.150000000000006,0,0]
["2020-21$",{"$f":"SUM(B8:B14)","v":146},{"$f":"SUM(C8:C14)","v":31170.136000000013},{"$f":"SUM(D8:D14)","v":4826085},{"$f":"SUM(E8:E14)","v":145508.668355},4.2330000000000005,{"$f":"SUM(G8:G14)","v":5298},{"$f":"SUM(H8:H14)","v":279.3286875},{"$f":"SUM(I8:I14)","v":4831383},{"$f":"SUM(J8:J14)","v":145787.99704250001},{"$f":"K14","v":98368},{"$f":"L14","v":3032.1699999999996},{"$f":"SUM(M8:M14)","v":303},9.5599999999999987,5,0.11,308,9.67,{"$f":"S14","v":59},{"$f":"T14","v":0.19}]
["2020-04-01",18,3043.8969999999999,491426,12560.803809999999,"Na","Na","Na",{"$f":"SUM(D8,G8)","v":491426},{"$f":"SUM(E8,H8)","v":12560.803809999999},69860,1730.2965362499999,20,0.68,1,0.02,21,0.70000000000000007,1,0.02]
["2020-05-02",19,2738.5650000000019,417099,11098.384330000001,1.357,1357,69.074012499999995,{"$f":"SUM(D9,G9)","v":418456},11167.4583425,63805,1656.4984999999999,50,1.53,0,0,50,1.53,50,0.13]
["2020-06-03",22,4488.21,664305,18815.042364999998,2.0209999999999999,2021,105.1227375,666326,18920.165102499999,65440,1778.5999999999997,80,2.65,0,0,80,2.65,80,0.26]
["2020-07-04",23,4228.302999999999,624760,18009.332005000007,0.85500000000000032,855,44.821050000000014,625615,18054.153055000006,65264,1959.0900000000004,2,0.1,0,0,2,0.1,0,0]
["2020-08-05",21,4991.0330000000022,761709,23905.798659999997,0.43800000000000017,438,23.934024999999995,762147,23929.732684999995,74187,2323.35889,0,0,0,0,0,0,0,0]
["2020-09-06",22,5512.668000000006,850386,28586.371479999998,0.21100000000000005,211,11.932862500000002,850597,28598.3043425,75975,2328.3580499999998,17,0.98,4,0.09,21,1.07,19,0.1]
["2020-10-07",21,6167.4600000000009,1016400,32532.935704999993,0.41600000000000004,416,24.443999999999996,1016816,32557.379704999992,98368,3032.1699999999996,134,3.62,0,0,134,3.62,59,0.19]
["$ indicates as on October 31, 2020"]
["Source: NCDEX",null,null," ",null,null,null," "," ",null,null,null,null,null,null,null,null,null," "]

{"sheet":"67","index":67,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,13,1,14],[1,0,2,0],[1,1,2,1],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,12]]}
["Table 67: Trends in Commodity Derivatives at ICEX"]
["Year/  Month","No.of Trading days","Agriculture Futures",null,null,"Metals Futures",null,null,"Gems and Stones Futures",null,null,"Total ",null,"Open interest at the end of the period"]
[null,null,"Volume \n('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume\n('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume \n(in cents)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)"]
["2019-20",259,821.73900000000015,268376,5353.5233730000009,2450.7099999999996,245071,7437.7322999999997,78395209,78395209,27720.037507274999,78908656,40511.292178220006,8290,19.32]
["2020-21$",{"$f":"SUM(B6:B12)","v":148},64.862700000000004,15864,307.63081300000005,251.66000000000003,25166,747.52123000000006,1457183,1457183,553.91163285999994,1498213,1609.0643258600001,{"$f":"N12","v":3},{"$f":"O12","v":1.0156950000000001E-3}]
["2020-04-01",18,50.837699999999998,9581,213.02189999999999,159.34,15934,472.86930000000001,655886,655886,250.5,681401,936.39175,14307,19.649999999999999]
["2020-05-02",21,10.79,3048,53.65,83.18,8318,246.82,641368,641368,242.99,652734,543.46,10497,15.64]
["2020-06-03",22,1.321,1321,16.16,8.4,840,25.6,153591,153591,58.103000000000002,155752,99.863,6912,7.45]
["2020-07-04",23,1.7410000000000001,1741,22.481598000000002,0.74,74,2.2319300000000002,5821,5821,2.0950948600000001,7636,26.80862286,3378,5.12059014]
["2020-08-05",21,0.17,170,2.2767149999999998,0,0,0,5,5,1.6379999999999999E-3,175,2.2783529999999996,36,0.48369600000000001]
["2020-09-06",22,3.0000000000000001E-3,3,4.0599999999999997E-2,0,0,0,176,176,0.1153,179,0.156,176,0.05]
["2020-10-07",21,0,0,0,0,0,0,336,336,0.1066,336,0.1066,3,1.0156950000000001E-3]
["$ indicates as on October 31, 2020"]
["Notes : Contract size for all diamond futures contract at ICEX is one cent. "]
["Source: ICEX",null,null,null,null,null," "]

{"sheet":"68","index":68,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,0,1,17],[2,0,3,0],[2,1,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,2,13],[2,14,2,15],[2,16,2,17],[17,8,18,8],[17,9,18,9],[26,0,26,8],[15,0,15,9],[16,0,18,0],[16,1,18,1],[16,2,16,5],[16,6,16,7],[16,8,16,9],[17,2,17,3],[17,4,17,5],[17,6,18,6],[17,7,18,7]]}
["Table 68: Trends in Commodity Derivatives Segment at BSE "]
["Futures"]
["Year/  Month","No.of Trading days","Metal ",null,null,"Bullion ",null,null,"Energy ",null,null,"Agriculture",null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Volume ( '000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ( '000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ( '000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ( '000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)"]
["2019-20",259,0.874,874,39.275199999999998,0.49412000000000017,41682,8836.5611850000005,422.85129336971352,30995,1246.95,6825.5123999999996,834466,36315.928845000002,908017,46438.715230000002,1,0.03]
["2020-21$",{"$f":"SUM(B7:B13)","v":147},0,0,0,6.6370000000000014E-4,423,33.799999999999997,0.35470668499999997,26,0.57201000000000002,799.5557500000001,107565,4309.8131300000005,108014,4344.1851399999996,{"$f":"Q13","v":83},{"$f":"R13","v":4.55}]
["2020-04-01",18,0,0,0,0,0,0,0,0,0,200.38050000000001,25734,1001.73313,25734,1001.73313,0,0]
["2020-05-02",20,0,0,0,0,0,0,0.35470668499999997,26,0.57201000000000002,165.684,21380,847.49,21406,848.06200999999999,50,2.64]
["2020-06-03",22,0,0,0,6.3370000000000006E-4,123,18.64,0,0,0,314.88175000000001,39937,1565.29,40060,1583.93,86,4.5199999999999996]
["2020-07-04",23,0,0,0,0,0,0,0,0,0,46.964500000000001,7891,323.74,7891,323.74,83,4.12]
["2020-08-01",21,0,0,0,0,0,0,0,0,0,19.513000000000002,3574,153.78,3574,153.78,67,4.08]
["2020-09-01",22,0,0,0,1.0000000000000001E-5,80,4.01,0,0,0,21.349,4042,181.2,4122,185.20999999999998,67,3.86]
["2020-10-01",21,0,0,0,2.0000000000000002E-5,220,11.15,0,0,0,30.783000000000001,5007,236.58,5227,247.73000000000002,83,4.55]
[]
[]
["Options"]
["Year / \nMonth","No.of Trading days","Bullion",null,null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Call Options ",null,"Put Options ",null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Notional Value \n(₹ crore)",null," "]
[null,null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)"]
["2020-21$",{"$f":"SUM(B21:B25)","v":109},{"$f":"SUM(C21:C25)","v":1667145},103145.29999999999,3447252,182054.11999999997,5114397,285199.42,{"$f":"I25","v":180},{"$f":"J25","v":0.54}]
["2020-06-01",22,298958,13332.21,294684,13484.56,593642,26816.769999999997,389,0.11]
["2020-07-01",23,267903,13424.07,1238158,58818.92,1506061,72242.989999999991,376,0.38]
["2020-08-01",21,344179,20187.25,1036730,51483.6,1380909,71670.850000000006,329,0.17]
["2020-09-01",22,377475,29792.17,354405,28539.24,731880,58331.41,38,0.09]
["2020-10-01",21,378630,26409.599999999999,523275,29727.8,901905,56137.399999999994,180,0.54]
["$ indicates as on October 31, 2020"]
["Conversion factors: Brent Crude Oil (1 Tonne = 7.33 Barrels)"]
["Source: BSE",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"69","index":69,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,11],[2,0,3,0],[2,1,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,9],[2,10,2,11],[17,8,18,8],[17,9,18,9],[15,0,15,9],[16,0,18,0],[16,1,18,1],[16,2,16,5],[16,6,16,7],[16,8,16,9],[17,2,17,3],[17,4,17,5],[17,6,18,6],[17,7,18,7]]}
["Table 69: Trends in Commodity Derivatives Segment at NSE"]
["Futures"]
["Year/  Month","No.of Trading days","Bullion ",null,null,"Energy",null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Volume ('000  tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000  tonnes)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)"]
["2019-20",259,2.1864300000000003E-2,65928,5773.6021940000001,0.01,79626,588.69708099999991,145554,6362.0044560000006,8,0.33]
["2020-21$",{"$f":"SUM(B7:B13)","v":148},{"$f":"SUM(C7:C13)","v":1.1604000000000002E-3},11559,560.21233100000006,0,0,0,11559,560.21233100000006,{"$f":"K13","v":5},{"$f":"L13","v":0.25}]
["2020-04-01",18,1.2560000000000002E-4,1256,57.360366999999997,0,0,0,1256,57.360366999999997,17,0.76]
["2020-05-02",21,1.6510000000000006E-4,1651,76.517431000000016,0,0,0,1651,76.517431000000016,3,0.14000000000000001]
["2020-06-03",22,4.4740000000000009E-4,4474,209.17937999999998,0,0,0,{"$f":"SUM(D9,G9)","v":4474},{"$f":"SUM(E9,H9)","v":209.17937999999998},18,0.87]
["2020-07-04",23,9.1099999999999992E-5,911,45.493170000000013,0,0,0,911,45.493170000000013,23,1.23]
["2020-08-05",21,1.7479999999999999E-4,1748,92.012484999999998,0,0,0,1748,92.012484999999998,7,0.36]
["2020-09-06",22,1.2850000000000003E-4,1240,65.526607000000013,0,0,0,1240,65.526607000000013,7,0.35]
["2020-10-07",21,2.7900000000000007E-5,279,14.122890999999999,0,0,0,279,14.122890999999999,5,0.25]
[]
[]
["Options"]
["Year / \nMonth","No.of Trading days","Bullion",null,null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Call Options ",null,"Put Options ",null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Notional Value \n(₹ crore)"]
[null,null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)"]
["2020-21$",{"$f":"SUM(B21:B25)","v":109},{"$f":"SUM(C21:C25)","v":162696},8311.6339384999992,112394,5648.9234594999998,275090,13960.557397999997,{"$f":"I25","v":4333},{"$f":"J25","v":222.55}]
["2020-06-01",22,21403,1028.3461460000001,15232,723.52905750000025,{"$f":"SUM(C21,E21)","v":36635},{"$f":"SUM(D21,F21)","v":1751.8752035000002},1181,56.33]
["2020-07-01",23,72333,3649.5826454999997,52135,2586.1723284999994,124468,6235.7549739999995,2760,140.36000000000001]
["2020-08-01",21,23412,1275.9778905000001,20669,1105.9422065000003,44081,2381.9200970000002,547,27.41]
["2020-09-01",22,19568,1017.1467119999999,14137,717.26084149999974,33705,1734.4075534999997,3787,191.08]
["2020-10-01",21,25980,1340.5805444999994,10221,516.0190255,36201,1856.5995699999994,4333,222.55]
["$ indicates as on October 31, 2020"]
["Source: NSE"]

{"sheet":"70","index":70,"n_rows":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,3,0],[1,1,1,4],[1,5,1,9],[1,10,1,13],[1,14,1,17],[1,18,1,19],[2,1,2,2],[2,3,2,4],[2,5,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[2,18,2,19]]}
["Table 70: Participant-wise percentage Share of Turnover in Commodity Derivatives at various Exchanges"]
["Year/ Month","MCX",null,null,null,"NCDEX",null,null,null,null,"ICEX",null,null,null,"BSE",null,null,null,"NSE"]
[null,"Agri Segment",null,"Non-Agri Segment",null,"Agri Segment",null,null,"Agridex Index",null,"Agri Segment",null,"Non-Agri Segment",null,"Agri Segment",null,"Non-Agri Segment",null,"Non-Agri Segment"]
[null,"Proprietary","Client ","Proprietary","Client ","Proprietary","Client ","Hedgers","Proprietary","Client ","Proprietary","Client ","Proprietary","Client ","Proprietary","Client ","Proprietary","Client ","Proprietary","Client "]
["2019-20",38.263375195290081,61.736624804709926,36.876706656365037,63.12329334363497,47.191851662479657,52.042840539860727,0.76530779765961998,"Na","Na",56.340391944940201,43.65960805505977,70.48881550130254,29.427851165364132,51.222352305710281,26.979500179821841,17.88576117747526,3.9123863369926166,45.265392816655925,54.734607183344067]
["2020-21$",35.154450706140707,64.845549293859293,38.686939114325,61.313060885675,43.353218119690339,55.446402447767085,1.2003794325425701,36.985860519607385,63.014139480392629,19.920000000000002,65.790000000000006,43.4,56.6,48.272003173310075,27.399490133238302,21.965661767991872,2.3628449254597514,58.158813762781911,41.841186237218089]
["2020-04-01",41.228984003003951,58.771015996996049,36.838343802546476,63.161656197453532,42.834718314098083,55.823640975250612,1.3416407106513035,"Na","Na",77.480720944400218,22.519279055599792,80.365906794025037,19.634093205974963,50.01482181187319,49.98517818812681,0,0,76.107388748053168,23.892611251946835]
["2020-05-02",41.821318486638738,58.178681513361262,36.500108639509506,63.499891360490487,44.723323322684053,53.650266114905719,1.6264105624102139,42.524685025355978,57.475314974644029,58.535423799125596,41.464576200874404,57.643030362191347,42.35696963780866,59.479613878105461,40.45293722799785,3.6347479141366774E-2,3.1101414755318409E-2,66.819481302240789,33.180518697759211]
["2020-06-03",34.190765817968924,65.809234182031091,36.838868889630874,63.161131110369126,40.512302721036029,57.699914565140674,1.787782713823292,37.108271890274899,62.891728109725101,2.0756957666838565,97.92430423331615,37.154911925855679,62.845088074144329,51.458204704071711,38.225415540006445,8.4310907466361549,1.8852890092856875,74.497235354489561,25.502764645510439]
["2020-07-04",32.390231614931196,67.609768385068804,39.618964978277624,60.381035021722383,41.66,56.87,1.48,43.08,56.92,0.45148703400000001,99.548512970000004,27.295211559999998,72.704788440000002,52.084026868729907,3.8613618610994438,44.02373052514934,3.0880745021307773E-2,54.198448050518522,45.801551949481471]
["2020-08-05",33.036061151514595,66.963938848485398,41.253630515101946,58.746369484898054,43.489080705325406,55.321404058039533,1.1895152366350599,23.829255630843537,76.170744369156466,0.89602782957023608,99.10397217042977,100,0,34.638388653719275,1.8862496689883581,63.358735468096661,0.11662620919570194,58.040692678827412,41.959307321172588]
["2020-09-06",33.385596883071301,66.614403116928671,39.143028076217234,60.856971923782766,45.33939711994536,53.996649498868123,0.66395338118652347,17.823101958980924,82.176898041019072,0,100,1.34,98.66,28.8556731302074,0.48881551196010087,68.056332496653596,2.5991788611789102,53.400583023714432,46.599416976285561]
["2020-10-07",35.29628375034202,64.703716249657973,37.670794055525562,62.329205944474438,43.823944307641462,55.189667542792698,0.98638814956585819,31.873286900670923,68.126713099329066,0,0,0,100,45.606222234790899,3.3669613432698227,33.49651800668714,17.530298415252137,53.128142534233469,46.871857465766531]
["$ indicates as on October 31, 2020"]
["Source: MCX, NCDEX, ICEX, BSE and NSE",null,null,null,null,null," ",null,null,null,null," "]

{"sheet":"71","index":71,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[40,1,40,9],[42,0,42,1],[46,0,46,8],[3,0,3,9],[4,1,4,9],[8,1,8,9],[15,1,15,9],[22,1,22,9],[30,0,30,1],[31,0,31,9],[32,1,32,9],[36,1,36,9]]}
["Table 71: Commodity-wise Turnover and Trading Volume at MCX"]
["Sr.No","Name of the Commodity","2020-21$",null,"2019-10-01",null,"2020-09-01",null,"2020-10-01"]
[null,null,"Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)"]
["Futures"]
["A","Bullion"]
[1,"Gold",2.6241471829999989,1299056.9163972996,0.35441075999999994,135195.22049910002,0.39860790400000007,202543.4457945,0.31007643899999998,157055.1992835]
[2,"Silver",252.03866800000006,1467908.4523548007,22.810248999999999,104156.48389820004,34.076212000000012,219835.18835739998,31.820741999999999,195823.4904558]
[null,"Total for A",{"$f":"SUM(C6:C7)","v":254.66281518300005},{"$f":"SUM(D6:D7)","v":2766965.3687521005},23.164659759999999,239351.70439730005,34.474819904000015,422378.63415189995,32.130818439000002,352878.6897393]
["B","Metals other than Bullion"]
[1,"Aluminium",1355.499,19141.793255,459.10100000000011,6122.3324650000004,219.82500000000002,3186.6012249999994,235.125,3519.3762749999996]
[2,"Copper",6470.1124999999993,314654.17210000003,878.77750000000015,38631.745225000006,1131.0624999999998,59269.068899999998,1046.1624999999997,54869.667625000002]
[3,"Lead",2754.1440000000002,40004.832585000026,929.548,14549.884815000001,489.03499999999997,7284.6160499999996,452.05000000000007,6703.9051500000005]
[4,"Nickel",3055.6005000000005,316771.43059499998,214.48425,26129.464885000001,462.51299999999998,50756.279849999992,492.66899999999998,55614.897914999987]
[5,"Zinc",7975.1830000000009,142129.22891000001,1770.1589999999999,32772.167444999999,1369.9650000000001,26414.599150000002,1298.6550000000002,25494.651150000002]
[null,"Total for  B",{"$f":"SUM(C10:C14)","v":21610.539000000001},{"$f":"SUM(D10:D14)","v":832701.45744500007},4252.0697500000006,118205.594835,3672.4004999999997,146911.165175,3524.6614999999997,146202.49811499999]
["C","Agricultural commodities"]
[1,"Cardamom",2.4699999999999982E-2,4.1452640000000027,0.1164,31.675529999999998,3.0000000000000003E-4,4.6399999999999997E-2,1E-3,0.14822499999999997]
[2,"Cotton",510.72674999999992,4948.8483250000027,90.040500000000009,1027.9815000000001,19.163250000000001,201.26445000000001,41.280250000000002,470.26760000000007]
[3,"CPO",4919.3499999999985,35179.829480000008,533.49000000000012,3024.54243,831.90000000000009,6430.8118700000005,818.38,6472.1449599999996]
[4,"Mentha Oil",8.8578000000000028,886.34343960000012,6.969240000000001,844.97424120000005,1.8468000000000002,176.46741,1.2916799999999999,121.61285999999998]
[5,"Kapas",32.036000000000008,163.13455000000002,11.28,60.765720000000002,5.8080000000000007,29.94173,5.8599999999999994,31.91648]
[null,"Total for C",{"$f":"SUM(C17:C21)","v":5470.9952499999981},{"$f":"SUM(D17:D21)","v":41182.301058600016},641.89614000000017,4989.9394211999997,858.7183500000001,6838.5318600000001,866.81293000000005,7096.0901249999997]
["D","Energy"]
[1,"Crude Oil",233141.96790989011,423426.97254999989,92280.016344881486,259465.29023600006,24137.626543720002,51388.29022000001,24606.357791989998,52340.207009999998]
[2,"Natural Gas (trln. Btu)",35469.428749999999,550004.77711249993,3013.6312500000008,51185.925337499997,6873.7662499999997,120104.0568125,7970,134680.52832500002]
[null,"Total for D",{"$f":"C24","v":233141.96790989011},{"$f":"SUM(D24:D25)","v":973431.74966249987},{"$f":"E24","v":92280.016344881486},{"$f":"SUM(F24:F25)","v":310651.21557350003},{"$f":"G24","v":24137.626543720002},{"$f":"SUM(H24:H25)","v":171492.34703250002},{"$f":"I24","v":24606.357791989998},{"$f":"SUM(J24:J25)","v":187020.73533500003}]
["E","Index Futures"]
[1,"iCOMDEX Bullion",155.23399999999998,12211.253145000001,"Na","Na",65.662000000000006,5182.9009949999991,63.268000000000001,4908.7176399999998]
[2,"iCOMDEX Metal",10.741999999999999,658.51666999999998,"Na","Na",null,null,10.741999999999999,658.51667000000009]
[null,"Total for E",null,{"$f":"SUM(D28:D29)","v":12869.769815},null,{"$f":"SUM(F28:F29)","v":0},null,{"$f":"SUM(H28:H29)","v":5182.9009949999991},null,{"$f":"SUM(J28:J29)","v":5567.2343099999998},null,null," "]
["Grand Total (A+B+C+D)",null,{"$f":"SUM(C8,C15,C22,C26)","v":260478.1649750731},{"$f":"SUM(D8,D15,D22,D26,D30)","v":4627150.6467332002},{"$f":"E30+E26+E22+E15+E8","v":97197.146894641483},{"$f":"SUM(F8,F15,F22,F26,F30)","v":673198.45422700001},{"$f":"G30+G26+G22+G15+G8","v":28703.220213624001},{"$f":"SUM(H8,H15,H22,H26,H30)","v":752803.57921439991},{"$f":"I30+I26+I22+I15+I8","v":29029.963040428996},{"$f":"SUM(J8,J15,J22,J26,J30)","v":698765.24762429995}]
["Options"]
["E","Bullion"]
[1,"Gold ",0.16930830000000011,83667.676180000024,1.933E-2,7451.9334249999993,4.1761200000000005E-2,21495.013758500001,1.1096100000000001E-2,5703.7147600000008]
[2,"Silver",3.5419499999999999,21202.917122999981,0.26637,1256.1545550000001,0.32187000000000004,2200.2195314999999,0.34869000000000006,2234.4132840000002]
[null,"Total  of E",{"$f":"SUM(C34:C35)","v":3.7112582999999999},{"$f":"SUM(D34:D35)","v":104870.593303},0.28570000000000001,8708.0879800000002,0.36363120000000004,23695.23329,0.35978610000000005,7938.128044000001]
["F","Metals "]
[1,"Copper",1.1324999999999994,51.468412499999985,0.63500000000000012,28.299495000000004,7.2500000000000009E-2,3.8159149999999999,4.5000000000000005E-2,2.4456225000000003]
[2,"Zinc",0.21500000000000002,3.6787550000000002,4.45,84.124340000000004,0,0,0,0]
[null,"Total of F",{"$f":"SUM(C38:C39)","v":1.3474999999999995},55.147167499999988,5.085,112.42383500000001,7.2500000000000009E-2,3.8159149999999999,4.5000000000000005E-2,2.4456225000000003]
["G","Energy"]
[1,"Crude Oil",10483.588146555001,20765.353181000006,3100.0136875150006,9038.8310799999981,1040.5457176800001,2328.1632559999998,889.46795287000009,1974.9516689999996]
["Grand Total (E+F+G)",null,{"$f":"SUM(C36+C40+C42)","v":10488.646904855001},{"$f":"SUM(D36+D40+D42)","v":125691.09365150001},{"$f":"SUM(E36+E40+E42)","v":3105.3843875150005},{"$f":"SUM(F36+F40+F42)","v":17859.342894999998},1040.9818488800001,26027.212460999999,889.87273897000011,9915.5253355000004]
["$ indicates as on October 31, 2020"]
["Note : 1. Natural Gas volume is in trillion BTU and is not included for computing the  total volume in \"000 tonnes\".",null,null,null,null,null,null," "]
["           2. Options includes both options on futures and goods"]
["           3.Conversion factors: Cotton (1 Bale=170 kg), Crude Oil (1 Tonne = 7.33Barrels)"]
["           4. Trading in iCOMDEX Bullion Futures and iCOMDEX Metal Future was launched on 24th Aug. 2020 and 19th Oct. 2020 respectively."]
["           5. iCOMDEX Bullion volumes are in '000 lots and is not included for computing the total volume in \"000 tonnes\"."]
["Source : MCX"]

{"sheet":"72","index":72,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[23,0,23,9],[3,0,3,9],[0,0,0,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9]]}
["Table 72: Commodity-wise Turnover and Trading Volume at NCDEX "]
["Sr.No","Name of Agri. Commodity ","2020-21$",null,"2019-10-17",null,"2020-09-18",null,"2020-10-18"]
[null,null,"Volume \n('000 tonnes)","Value\n(₹ crore)","Volume \n('000 tonnes)","Value\n(₹ crore)","Volume \n('000 tonnes)","Value \n( crore)","Volume ('000 tonnes)","Value\n(₹ crore)"]
["Futures"]
[1,"AGRIDEX   Index ",5.2980000000000018,279.3286875,"Na","Na",0.21100000000000005,11.932862500000002,0.41600000000000004,24.443999999999996]
[2,"Barley",29.380000000000003,43.502695000000003,1.1499999999999999,2.2100000000000009,1.2500000000000002,1.7216200000000002,1.9900000000000002,2.6960999999999999]
[3,"Castorseed",1112.96,4439.7035700000006,762.80499999999995,3481.5700000000006,184.83999999999997,763.22192000000018,201.14999999999998,858.66199999999992]
[4,"Chana",5281.56,24971.516219999998,839.61,3682.0299999999993,1329.86,6845.9060299999992,1044.2600000000002,5712.455509999998]
[5,"Cotton seed oil cake",5184.04,10118.295610000001,742.49,1624.7099999999998,456.44000000000005,829.38786000000016,511.46999999999997,942.22069999999997]
[6,"Coriander",224.77999999999997,1402.5218100000002,136.80000000000001,841.24000000000012,28.500000000000004,191.61006,21.225000000000001,142.88784000000001]
[7,"Guar seed",3883.3,15132.874380000001,983.22,3874.9699999999984,631.82500000000005,2524.5628550000001,852.57499999999993,3559.3892850000002]
[8,"Guargum",2332.2849999999999,13991.63134,339.26,2534.31,363.67,2248.5944300000001,405.70000000000005,2592.9850899999992]
[9,"Jeera",118.815,1654.1132249999998,32.847000000000001,543.95999999999992,18.902999999999999,262.84424999999999,21.183,296.77267499999999]
[10,"Kapas",241.238,1257.8682100000001,21.802,470.36,47.740000000000009,245.91925000000003,97.772000000000006,536.67622000000006]
[11,"Maize",17.369999999999997,22.231370000000002,1.36,2.88,0.75,1.0092099999999999,0.10999999999999999,0.14336999999999997]
[12,"Moong",0.02,0.14129999999999998,0.82,5.1100000000000003,0,0,0.01,7.4999999999999997E-2]
[13,"RM seed",3756.2,18979.667990000002,509.33,2120.2999999999997,782.25000000000011,4224.2285899999997,690.22,3915.8434199999997]
[14,"Soy bean",4930.57,19417.496585000001,1187.94,4458.7799999999988,866.58499999999992,3389.934385,1461.85,6127.7297299999991]
[15,"Refined Soy Oil",3689.2149999999997,31953.724340000001,326.91000000000003,2487.8799999999997,728.67499999999995,6635.0179400000006,789.80999999999983,7444.1192850000007]
[16,"Turmeric",368.18,2121.6325099999999,104.845,627.74999999999977,71.325000000000003,421.93212999999997,68.054999999999993,399.56277999999998]
[17,"Wheat",0.01,1.7999999999999999E-2,3.87,8.1399999999999988,0,0,0,0]
[18,"Sesameseed",0.19500000000000001,1.7292000000000001,"Na","Na",5.4999999999999993E-2,0.48094999999999999,8.0000000000000016E-2,0.7167]
[" ","Total",{"$f":"SUM(C5:C22)","v":31175.416000000001},145787.99704250001,5995.0590000000011,26766.199999999997,5512.8789999999999,28598.304342500003,6167.8760000000002,32557.379704999999]
["Options",null,null,null,null,null,null,null,null,null,null,null," "]
[1,"Chana",0.18000000000000002,1.43,0.03,0.12,0.17,0.98,0,0,null,null," "]
[2,"Guargum",0.90999999999999992,5.9700600000000001,"Na","Na","Na","Na",0.21,1.56]
[3,"Guarseed",0.47000000000000003,2.0773250000000001,0.01,0.04,"Na","Na",0.46,2.06]
[4,"Soybean",0.02,0.09,"Na","Na",0.02,0.09,0,0]
[5,"RM Seed",0.02,0.1,"Na","Na","Na","Na",0,0]
[null,"Total",{"$f":"SUM(C25:C29)","v":1.5999999999999999},9.6673849999999995,0.04,0.16,0.19,1.07,0.67,3.62]
["$ indicates as on October 31, 2020",null,null,null,null,null," "," ",null," "]
["Note: AGRIDEX volume are in '000 lots and is not included for computing the total volume in \"000 tonnes\" .",null,null,null,null,null,null," "]
["Source: NCDEX",null,null,null," ",null,null,null," "]

{"sheet":"73","index":73,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[76,1,76,9],[77,1,77,9],[19,1,19,9],[36,1,36,9],[62,1,62,9]]}
["Table 73: Commodity-wise Turnover and Trading Volume at ICEX, BSE and NSE",null,null,null,null,null," "," "]
["Sr.No","Name of the Commodity","2020-21$",null,"2019-10-01",null,"2020-09-01",null,"2020-10-01"]
[null,null,"Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)"]
["I","ICEX Futures",null,null,"ICEX"]
["A","Gems & Stones"]
[1,"Diamond 1 CT",14575.1,554.03,68530.539999999994,2436.5500000000002,3.82,0.1153,3.36,0.1066]
[2,"Diamond .5 CT",0.09,1.477E-3,0.51,0.01,"Na","Na","Na","Na"]
[3,"Diamond .3 CT","Na","Na",2.88,0.03,"Na","Na","Na","Na"]
[null,"Total for A",null,{"$f":"SUM(D6:D8)","v":554.031477},null,{"$f":"SUM(F6:F8)","v":2436.5900000000006},null,{"$f":"SUM(H6:H8)","v":0.1153},null,{"$f":"SUM(J6:J8)","v":0.1066}]
["B","Metal other than gems & stones"]
[null,"Steel Long",251.66,747.51869999999997,211.34,591.97,0,0,0,0]
[null,"Total for B",{"$f":"SUM(C11)","v":251.66},747.51869999999997,211.34,591.97,{"$f":"SUM(G11)","v":0},{"$f":"SUM(H11)","v":0},0,0]
["C","Agricultural Commodities"]
[1,"Isabgulseed ","Na","Na",1.32,11.77,"Na","Na","Na","Na"]
[2,"Pepper Mini","Na","Na",1.56,49.91,"Na","Na","Na","Na"]
[3,"Rubber ",10.42,122.58546199999999,4.18,50.88,3.0000000000000001E-3,4.1000000000000002E-2,0,0]
[4,"Paddy Basmati",54.44,185.04285999999999,64.19,221.23,"Na","Na","Na","Na"]
[null,"Total for C",{"$f":"SUM(C14:C17)","v":64.86},307.62832199999997,71.25,333.78999999999996,3.0000000000000001E-3,4.1000000000000002E-2,{"$f":"SUM(I12,I14:I17)","v":0},0]
[null,"Total - ICEX Futures (A+B+C)",{"$f":"SUM(C12,C18)","v":316.52},{"$f":"SUM(D9,D12,D18)","v":1609.1784990000001},{"$f":"SUM(E12,E18)","v":282.59000000000003},{"$f":"SUM(F9,F12,F18)","v":3362.3500000000004},{"$f":"SUM(G12,G18)","v":3.0000000000000001E-3},{"$f":"SUM(H9,H12,H18)","v":0.15629999999999999},{"$f":"SUM(I12,I18)","v":0},{"$f":"SUM(J9,J12,J18)","v":0.1066}]
["II","NSE",null,null,null,null,null,null,null,null,null," "]
[null,"NSE Futures",null,null,null,null,null,null," "," "]
["A","Bullion"]
[1,"Gold",5.0000000000000004E-6,2.5385900000000001,2.0749999999999996E-3,791.56914999999992,5.0000000000000004E-6,2.5385900000000001,0,0]
[2,"Gold Mini",1.1554E-3,557.67374100000006,7.8800000000000004E-5,30.091974000000004,1.2350000000000002E-4,62.988016999999999,2.7900000000000007E-5,14.122890999999999]
[3,"Silver",0,0,0,0,0,0,0,0]
[null,"Total for A",{"$f":"SUM(C23:C25)","v":1.1604E-3},560.21233100000006,{"$f":"SUM(E23:E25)","v":2.1537999999999996E-3},{"$f":"SUM(F23:F25)","v":821.66112399999997},1.2850000000000003E-4,65.526606999999998,2.7900000000000007E-5,14.122890999999999]
["B","Energy",null,null,null,null,null,null,null," "]
[1,"BR Crude",0,0,2.0600272851296044E-5,6.4493800000000014,0,0,0,0]
[2,"BR Crude Mini",0,0,1.2489768076398363E-3,38.783098000000003,0,0,0,0]
[null,"Total for B",{"$f":"SUM(C28:C29)","v":0},{"$f":"SUM(D28:D29)","v":0},{"$f":"SUM(E28:E29)","v":1.2695770804911322E-3},{"$f":"SUM(F28:F29)","v":45.232478},{"$f":"SUM(G28:G29)","v":0},0,0,0]
[null,"Total -NSE Futures (A+B)",{"$f":"SUM(C26,C30)","v":1.1604E-3},{"$f":"SUM(D26,D30)","v":560.21233100000006},3.423377080491132E-3,866.89360199999999,1.2850000000000003E-4,65.526606999999998,2.7900000000000007E-5,14.122890999999999]
[null,"NSE Options"]
["C","Bullion"]
[null,"Gold Mini",2.7509000000000006E-2,13960.557397999997,0,0,3.3705000000000002E-3,1734.4075534999997,3.6201000000000007E-3,1856.5995699999994]
[null,"Total - NSE Options( C)",{"$f":"SUM(C34)","v":2.7509000000000006E-2},13960.557397999997,0,0,3.3705000000000002E-3,1734.4075534999997,{"$f":"SUM(I34)","v":3.6201000000000007E-3},{"$f":"SUM(J34)","v":1856.5995699999994}]
[null,null,null,null,null,null,null,null," "]
["III"," "]
[null,"BSE Futures ",null,null,null,null,null,null,null," "]
["A","Bullion"]
[1,"Gold",3.0000000000000001E-5,12.07,7.6300000000000001E-4,290.89202999999998,0,0,0,0," ",null," "]
[2,"Silver",5.9999999999999995E-4,2.91,5.8499999999999993E-3,26.566299000000001,0,0,0,0]
[3,"Silver KG",0,0,0,0,0,0,0,0]
[4,"Silver M",0,0,0,0,0,0,0,0]
[null,"Gold M",2.2015699999999999E-2,18.829681000000001,0,0,7.9999999999999996E-6,4.0066800000000002,2.1999999999999999E-2,11.15118]
[null,"Total for A",{"$f":"SUM(C40:C44)","v":2.2645699999999998E-2},33.809680999999998,{"$f":"SUM(E40:E44)","v":6.6129999999999991E-3},317.45832899999999,7.9999999999999996E-6,4.0066800000000002,2.1999999999999999E-2,11.15118]
["B","Metals other than Bullion"]
[null,"Copper",0,0,0,0,0,0,0,0]
[null,"Total for B",{"$f":"SUM(C47)","v":0},0,0,0,0,0,0,0]
["C","Agricultural Cmmodities",null,null,null,null,null,null,null," "]
[1,"Guar Gum",0,0,0,0,0,0,0,0]
[2,"Guar Seed",467.96999999999997,1652.09934,531.25,2088.7794349999999,0,0,0,0]
[3,"Cotton",0,0,0,0,0,0,0,0]
[4,"Turmeric",173.05,978.61878000000013,19.21,110.62779,19.23,113.34481,28.64,168.09714]
[null,"Cotton BSE",0,0,41.126400000000004,467.93045999999998,0,0,0,0]
[null,"Soybean",0,0,14.72,54.663429999999998,0,0,0,0]
[null,"Castorseed",0,0,3.46,15.525180000000001,0,0,0,0]
[null,"Chana",0,0,9.11,40.607089999999999,0,0,0,0]
[5,"Cotton29",150.47975000000002,1423.7491749999999,0,0,0,0,0,0]
[6,"BSE Almond",8.0560000000000009,255.35388,0,0,2.1190000000000002,67.857060000000004,2.1190000000000002,68.484669999999994]
[null,"Total for C",{"$f":"SUM(C50:C59)","v":799.55574999999999},{"$f":"SUM(D40:D44,D47,D50:D59)","v":4343.6308559999998},{"$f":"SUM(E50:E59)","v":618.8764000000001},2778.1333850000001,21.349,181.20186999999999,30.759,236.58180999999999]
["D","Energy",null,null,null,null,null," "]
[null,"Brent Crude",0.35470668499999997,0.57201000000000002,0,0,0,0,0,0]
["C.","NSE",null,null,null,null,null,null,null,null,null," "]
[1,"Gold",null,null,"Na","Na","Na","Na"]
[2,"Silver",null,null,"Na","Na","Na","Na"]
[null,"Total (NSE)",null,696.19,"Na","Na","Na","Na",null,696.19]
[null,"Total for D",{"$f":"SUM(C62)","v":0.35470668499999997},0.57201000000000002,0,0,0,0,0,0,null," "]
[null,"Total- BSE Futures (A+B+C+D)",{"$f":"SUM(C40:C44,C47,C50:C59,C62)","v":799.9331023850001},{"$f":"SUM(D40:D44,D47,D50:D59,D62)","v":4344.2028659999996},{"$f":"SUM(E45,E48,E60,E67)","v":618.88301300000012},3095.5917140000001,21.349008000000001,185.20854999999997,30.780999999999999,{"$f":"SUM(J45,J48,J60,J62)","v":247.73299}]
[null,"BSE Options"]
["E","Bullion"]
[null,"Gold",7.3050999999999991E-2,37506.805395000003,0,0,4.4628999999999995E-2,22857.065715000001,2.3033000000000001E-2,11826.02968]
[null,"Silver",0.23913000000000001,1523.756666,0,0,0.13700999999999999,888.64673249999998,9.5640000000000003E-2,592.2499335]
[null,"Silver KG",7.2736000000000009E-2,419.57348090000005,0,0,9.5060000000000006E-3,60.652085249999999,1.3368E-2,83.551395650000003]
[null,"Gold M",0.49606390000000006,245749.29129124997,0,0,6.7317800000000011E-2,34525.052683499998,8.6231600000000005E-2,43635.56575075]
[null,"Total - BSE Options",{"$f":"SUM(C71:C74)","v":0.88098090000000007},285199.42683314998,0,0,0.25846279999999999,58331.417216250004,0.21827259999999998,56137.396759900003]
["$ indicates as on October 31, 2020"]
["     Note:","1 Volume for Diamond 1 CT, 0.5CT & 0.3CT are in cents and are not added to the total volume as they cannot be converted into \"000 tonnes\"."]
[null,"2 Conversion factors: Brent Crude Oil (1 Tonne = 7.33 Barrels)"]
["Source : ICEX, BSE and NSE",null,null,null,null,null,null,null," "," "]

{"sheet":"74","index":74,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Table 74:  Macro Economic Indicators"]
["I. GDP at Current prices for 2019-20 (` crore)#                         ",null,null,null,null,"2,03,39,849"]
["II. Gross Saving as a per cent of Gross national Disposable Income at current market prices in 2018-19!",null,null,null,null,29.7]
["III. Gross Fixed Capital Formation as a per cent of GDP at current market prices in 2019-20#",null,null,null,null,29.8]
["IV.  Monetary and Banking Indicators                  ","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01"]
["Cash Reserve Ratio (per cent)",3,3,3,3,3]
["Repo Rate (per cent)",4,4,4,4,4]
["Money Supply (M3)  (₹ billion)",173153.64,174906.73,176478.74,177410.65,178048.85]
["Aggregate Deposit (₹ billion)",138671.14000000001,140204.87,141767.65,142636.74,142926.24]
["Bank Credit (₹ billion)",102450.3,102194.62,102117.3,102718.57,103388.53]
["V. Interest Rate                        "]
["Call Money Rate (Weighted Average)",3.54,3.46,3.43,3.41,3.41]
["91-Day-Treasury Bill (Primary Yield)",3.19,3.3,3.24,3.36,3.36]
["Base rate (per cent)","7.40/9.00","7.40/9.00","7.40/9.00","7.40/9.00","7.40/8.80"]
["Term Deposit Rate > 1 year (Maximum) ","5.10/5.65","5.10/5.50","5.00/5.50","4.90/5.50","4.90/5.50"]
["VI. Capital Market Indicators (₹crore)"]
["Equity Cash Turnover (BSE+NSE) ",1460873.4239999999,1428613.7250000001,1375636.4949999999,1293354.004,{"$f":"SUM('[1]16'!B3,'[1]16'!B5)","v":1156750.075}]
["Market Cap-BSE ",13915689.83,14739115.83,15376302.710000001,15524267.369999999,{"$f":"'[1]17'!M5","v":15792249.91}]
["Market Cap-NSE ",13804601.48,14629658.609999999,15234206.699999999,15304722.35,{"$f":"'[1]18'!M5","v":15587902.939999999}]
["Net FPI Investment in Equity ",21832,7563,47080,-7783,19541]
["VII. Exchange Rate and Reserves"]
["Forex Reserves (USD million)",506838,534568,542013,545638,568494]
["Re/ Dollar",75.527000000000001,74.77,73.349999999999994,73.73,73.97]
["Re/Euro",84.665800000000004,88.87,87.07,86.04,86.97]
["Forward Premia of USD  6-month",3.82,3.8,4.01,3.91,3.89]
["VIII.  Public Borrowing and Inflation"]
["Govt. Market Borrowing-Gross (₹ billion)","3,140^","4,820^","6,460^","7660^","8760^"]
["Wholesale Price Index (2011-12=100)",119.3,120.6,121.7,122.9,"NA"]
["Consumer Price Index (2012 =100)",151.80000000000001,154.19999999999999,155.4,156.4,158.4]
["IX.  Index of Industrial Production (Base year 2011-12 = 100)"]
["General",108.9,117.6,116.1,123.2,"NA"]
["Mining",85.4,87.4,83,87.6,"NA"]
["Manufacturing",108.4,118.2,117.4,125.3,"NA"]
["Electricity",156.19999999999999,166.3,162.69999999999999,166.4,"NA"]
["X. External Sector Indicators (USD million)"]
["Exports ",21907.55,23642.85,22700,27580,24890]
["Imports",21114.38,28469.11,29470,30310,33610]
["Trade Balance",793.16999999999825,-4826.260000000002,-6770,-2730,{"$f":"F36-F37","v":-8720}]
["Notes: "]
["# Provisional Extimates as per MOSPI press release dated 31.05.2020"]
["^ cumulative figure value of the respective month for 2020-21 "]
["Data for CPI, WPI, IIP and External sector have been complied based on available information."]
[" @ All Commodities WPI could not be computed for April-2020 due to non availability of manufactured product group index"]
["Source :  RBI, FBIL,  MOSPI,  Ministry of Commerce & Industry, Office of the Economic Adviser."]